Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find the first letter in a cell
In one column I have a text contaning numbers and letters e.g.:
10S1 143W1 1A9 etc. I want a second column containing only the first letter of these text. This letter can be found anywhere between the 1st and 5th position in the cell and can be any capital letter. Can anyone help me with this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find cell containing a letter | Excel Discussion (Misc queries) | |||
Find column letter of the first unused cell | Excel Worksheet Functions | |||
FIND LETTER IN CELL (cond. form mult entries not wrking) | Excel Discussion (Misc queries) | |||
find column letter | Excel Discussion (Misc queries) | |||
How do I find a cell starting with a specific letter? | Excel Discussion (Misc queries) |