| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract a number(s) from a text string
I have an single column of data (see below) that randomly has numbers inserted at the beginning of the text. The database unfortunately cannot be altered at this time, so I'm stuck. I need this data in two columns. Obviusly "text to columns" won't work, or I wouldn't be asking for help. Anyone have any suggestions? 57NORCROSS EAST 213DUBLIN 57NORCROSS WEST 48DOWNTOWN NORTH 26MCDONOUGH 48DOWNTOWN SOUTH 53NEWNAN 134BUFORD 135MACON 134SUWANEE 121FULTON INDUSTRIAL SOUTH 59LAWRENCEVILLE 1009AUSTELL 134DULUTH 130LITHIA SPRINGS 106ROSWELL 7WEST GEORGIA 123DAWSONVILLE 100CEDARTOWN 125MARIETTA SOUTH 154ROME 5HOOTCH[/i][/i] -- Christopher770 ------------------------------------------------------------------------ Christopher770's Profile: http://www.thecodecage.com/forumz/member.php?userid=188 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=77789 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract number from text string based on number's format? | Excel Discussion (Misc queries) | |||
| How to extract left-most number from a string | Excel Worksheet Functions | |||
| Extract a number from a variable text string | Excel Discussion (Misc queries) | |||
| Extract number from text/number string.. | Excel Discussion (Misc queries) | |||
| How to extract the Number from a String | New Users to Excel | |||
Threaded Mode
