split column in more columns excel
ibarrera - April 7, 2006 - 21:22
| Project: | Import Typepad / MoveableType |
| Version: | HEAD |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | ibarrera |
| Status: | active |
Jump to:
Description
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@mexico.com
#1
#2
replace empty space with comma, import into spreadsheet.
transpose (row -->column)