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