Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stripping text before a number (alpha or numeric)
I have a column that's supposed to be an address, but somehow got the
company name mixed in at the beginning: 123 Main Street One Park Place Acme Company, Inc. 456 Easy Street Alpha-Omega Dry Cleaning Four-Twenty Highway One I can use the formula =RIGHT(A1,(LEN(A1)-((MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789" )-1))))) for stripping the text before an actual number Acme Company, Inc. 456 Easy Street to 456 Easy Street BUT - I'm not sure how to strip before a text representation of a number (one, two, three, etc) Alpha-Omega Dry Cleaning Four-Twenty Highway One to Four-Twenty Highway One Any suggestions??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Setting the number of decimal places for a text box. | Excel Discussion (Misc queries) | |||
Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
Change number format from text to number? | New Users to Excel | |||
Change number (in text format) to numeric format | Excel Discussion (Misc queries) |