Get substring in Excel

Posted By:Hiren Soni Posted Date: August 31, 2010 Points: 10 Category: Microsoft Dynamics URL: http://www.dotnetask.com

Here iwill show how you can get substring in excel

=MID(A1,0,10)

=mid(string,start_index,length");

if a1 = "hello"

then =mid(a1,1,3) gives "hel"

Further Readings:

How to open .doc,.pdf.ms-excel files in asp.net 2.0..
Import Excel Data into SQLServer
Create Excel Application
Export to Excel in VB.NET
Export Grid To Excel
Validate PAN in excel through VBA macro
Create Excel in Run Time in VB.NET
Excel chart & series object creation
To open an workbook in a excel file with excel.application
Running auto macros using Excel.application

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply

Read also another Resources from the same Author get the Ip address of Client Machine encrypt field value in sql server using PWDENCRYPT Get top records from sql query Encrypt values in MYSQL store password text in passoword textbox	Related Resource From The Same Category
Find More code samples in C#, ASP.Net, Vb.Net and more Here

Get substring in Excel

Further Readings:

Read also another Resources from the same Author

Related Resource From The Same Category