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