On Mar 21, 7:43 am, Christopher770
wrote:
I have an single column of data (see below) that randomly
has numbers inserted at the beginning of the text. [....]
I need this data in two columns.

I would write a macro. Are you interested in a VBA solution?

Alternatively, I would put the following formula into a parallel
column (say column D):

=MIN(FIND
({"A","B","C","D","E","F","G","H","I","J","K","L", "M","N","O","P","Q","R","S","T","U","V","W","X","Y ","Z"},A1&"ABCDEFGHIJKLMNOPQRSTUVWXYZ")-1))

In another parallel column (say column B), put:

=--LEFT(A1,D1-1)

In yet another parallel column (say column C), put:

=RIGHT(A1,LEN(A1)-D1+1)

If you want to "replace" the column of original data (column A in my
example), copy-and-paste-special-value the columns with the LEFT and
RIGHT formulas. Then delete the columns with the FIND formula and the
original data.

HTH.


----- original posting -----

On Mar 21, 7:43*am, Christopher770
wrote:
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]

--
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[/i]