split text into more columns excel
 

dear all, could be posible to split column with text, information into
more columns, example
i need to make a macro, because i have more than 1000 files.
17 COTAXTLA 7929 4090 125 62 200 105 4.6
2.3 10.1 3.5 2.8 1.5 3.0
5 COTAXTLA 7822 4076 124 62 187 99 4.7
1.8 9.9 4.0 3.3 2.5 3.0
4 COTAXTLA 7921 4004 122 62 205 114 7.4
2.8 10.5 3.5 2.5 2.3 3.0

when i import from excel appear in column A, then i need information
in
columns a1 17
colum b1 cotaxtla 7929
colum c1 4090
colum d1 125 etc.

y next row
a2 5
b2 cotaxtla 7822

etc. etc.
can anyone help me.
thanks


--
ibarrera
------------------------------------------------------------------------
ibarrera's Profile: http://www.excelforum.com/member.php...o&userid=33282
View this thread: http://www.excelforum.com/showthread...hreadid=531085

split text into more columns excel
 

select column A and do Data=Text to Columns. Go through the wizard.

--
Regards,
Tom Ogilvy

"ibarrera" wrote in
message ...

dear all, could be posible to split column with text, information into
more columns, example
i need to make a macro, because i have more than 1000 files.
17 COTAXTLA 7929 4090 125 62 200 105 4.6
2.3 10.1 3.5 2.8 1.5 3.0
5 COTAXTLA 7822 4076 124 62 187 99 4.7
1.8 9.9 4.0 3.3 2.5 3.0
4 COTAXTLA 7921 4004 122 62 205 114 7.4
2.8 10.5 3.5 2.5 2.3 3.0

when i import from excel appear in column A, then i need information
in
columns a1 17
colum b1 cotaxtla 7929
colum c1 4090
colum d1 125 etc.

y next row
a2 5
b2 cotaxtla 7822

etc. etc.
can anyone help me.
thanks


--
ibarrera
------------------------------------------------------------------------
ibarrera's Profile:
http://www.excelforum.com/member.php...o&userid=33282
View this thread: http://www.excelforum.com/showthread...hreadid=531085