Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can I execute and 'substring' function in Excel
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can I execute and 'substring' function in Excel
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 ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can I execute and 'substring' function in Excel
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|