Home |
Search |
Today's Posts |
#1
|
|||
|
|||
extracting text only
I have a column in a spreadsheet that contains a code. The code starts
with 2 - 4 letters then finishes with a series of numbers. E.G. AGB7655 How can I extract only the letters at the beginning, when I don't know how many there are going to be? |
#2
|
|||
|
|||
ASAP Utilities, a free Excel Add-in, has this as one of it's
features....."Delete all numbers in selection"..........it works good http://www.asap-utilities.com/index.php?page=p_ho.php Vaya con Dios, Chuck, CABGx3 "Keith" wrote in message ... I have a column in a spreadsheet that contains a code. The code starts with 2 - 4 letters then finishes with a series of numbers. E.G. AGB7655 How can I extract only the letters at the beginning, when I don't know how many there are going to be? |
#3
|
|||
|
|||
Try the following...
=LEFT(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123 456789"))-1) Hope this helps! In article , Keith wrote: I have a column in a spreadsheet that contains a code. The code starts with 2 - 4 letters then finishes with a series of numbers. E.G. AGB7655 How can I extract only the letters at the beginning, when I don't know how many there are going to be? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Extracting and using Text from external sources | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
EXTRACTING TEXT | Excel Discussion (Misc queries) | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |