If there is only one set of spaces, you could use DataText To Columns with
a space delimiter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Eve" wrote in message
...
Help!! Is there a way to split a single column into 2 separate columns. I
have 6882 rows of info I need to split. Each row starts with 5 numbers,
then
2 spaces, followed by phrases. Thanks!!