| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I separate the alpha prefix from a text (abc123 or a1234)?
I cannot use Text-to-column as the alpha spacing is inconsistent. Is there a
formula that I can use to pull the alpha (or numberic) prefix from a text in Excel. Ex: abc123 ab1234 abcd12345 123abc 12abcde Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I separate the alpha prefix from a text (abc123 or a1234)?
ASAP Utilities, a free Add-in available at www.asap-utilities.com has
features that will delete all alpha characters and/or all numeric characters.......... Vaya con Dios, Chuck, CABGx3 "kskaug1" wrote: I cannot use Text-to-column as the alpha spacing is inconsistent. Is there a formula that I can use to pull the alpha (or numberic) prefix from a text in Excel. Ex: abc123 ab1234 abcd12345 123abc 12abcde Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| How can I convert digits to alpha text? | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Hybrid Mode
