View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default 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