can I execute and 'substring' function in Excel
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
...
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
|