Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
separate letters from cell
Hi, can someone help me with the following:
In 400 cells I have a name + a code with three letters, for example: Mister Blackwell RRT. I would like 'Mister Blackwell' in one cell, and 'RRT' in another cell. Is it possible to separate the three letter code from the name? Thanks a lot in advance. Marieke |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting numbers and letters in a single cell to separate cells | Excel Discussion (Misc queries) | |||
How I separate first two letters of the sentence in msexcel | Excel Discussion (Misc queries) | |||
How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) | |||
Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) |