How to extract the first 100 characters from a excel cell using vba

In this example I will tell you how you can extract the first 100 characters from a excel cell using vba

Say Call A1 has the value In this example I will tell you how you can extract the first 100 characters from a excel cell using vba

In Cell B1 write the function =MID(A1,1,100). You will see cell B1 will have the text In this example I will tell you how you can extract the first 100 characters from a excel cell using.