split a single column into 2 separate columns

G

Guest

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

Bob Phillips

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

--

HTH

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split column contents (de-concantenate) 7
Parsing Column of Numbers into 5 separate columns 1
Splitting contents of column into 4 3
Splitting Text from single cell in column across multiple Columns 3
I have a column of many many numbers how can i split them up auto 1
Split Text into Two Columns 1
Excel Count number of instances in a column 1
data in single column split to multiple col's based on header 2

Top