| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extracting Data
if you have data in the same format then use the following function. if your data starts from A1 put in B1 =MID(A1,1,2) Aoife101 Wrote: 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. -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=557231 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extracting Data
That worked thanks so much! :) -- Aoife101 ------------------------------------------------------------------------ Aoife101's Profile: http://www.excelforum.com/member.php...o&userid=35928 View this thread: http://www.excelforum.com/showthread...hreadid=557231 |
| Reply |
| 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) | |||
Hybrid Mode
