split a single column into 2 separate columns
 

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!!

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!!

Asuming the data is like 11111 sfsdfsf -in column a
In column b use=LEFT(A1,5)
In column c use =TRIM(MID(A1,8,15))

HTH


"Eve" wrote:

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!!