MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Finding specific string value


Posted by Steven Pinon on November 03, 2000 8:19 AM

I know this can be done but can't remember how....

If in A1 I had "ABCDEFG" then how do I make it so that cell C1 could return the letter in say third position in the string? In effect what I want is to have a list of company names in the A column and then get column B to be equal to the first 5 letters oif the names so Microsoft would come out as Micro and McDonalds would come out as McDon etc etc.....

help me!


Posted by Ben O. on November 03, 2000 8:45 AM

This is an easy one:

=LEFT(A1,5)

If you wanted the third character only:

=RIGHT(LEFT(A1,3),1)


-Ben

Posted by Aladin.Akyurek on November 03, 2000 11:22 AM

=MID(a1,1,5)

would give you McDon if a1="McDonalds".

Cheers.

Aladin