ExcelBanter - View Single Post - can I execute and 'substring' function in Excel

wrote
I have a cell that I need to fiding out what the 1st two characters
in the cell are AND then put a related character in another column.
Can I do this in Excel??????
--
Larry

Hi Larry
Thanks for the feedback.
I'm still not sure what you were actually trying to achieve, but if my
pointers helped then that's good.
Happy New Year to you also.

--
Regards

Roger Govier

Larry wrote:
Roger,
Thanks a bunch. I've spent about 8 hours trying different functions
without any success. The three functions you gave me all worked but I
had to use =CODE and wrap it in an =IF statement so I could add the
column.
I will be sure to use this site more often.
Absolutely a great job!
Happy New Year!
--
Larry

"Roger Govier" wrote:

Hi Larry

=LEFT(A1,1) will return the first character within cell A1
as will =MID(A1,1,1)
=MID(A1,2,1) will return the second character.

=CODE(MID(A1,1,1)) will return the ASCII code number of the first
character

I hope that this will get you started.

--
Regards

Roger Govier

"Larry" wrote in message