| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Data
Hey all If I have a column with a list of reference codes such as: Ab101 Ne444 Af876 Ne254 Sd345 Sd654 Is there any formula that will allow me to extract the letters eg. Ab, Ne etc. into the following column?? Any suggestions would be great. -- Aoife101 ------------------------------------------------------------------------ Aoife101's Profile: http://www.excelforum.com/member.php...o&userid=35928 View this thread: http://www.excelforum.com/showthread...hreadid=557231 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Extracting data from two columns | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
Threaded Mode
