| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Seperate row to Column.
Hi,
I got the address file. The all in one Colume (A) with alot of rows. Each address file seperate by the empty row. How can I got the each address file from each row to columns. Examples of two address record; Column A ======== AAA xxx 123 st sss,fff xxxx BBB ZZZ 345 sr ggg, hhhh jjdld TO Column A Column B Column C Column D =============================================== AAA xxx 123 st sss, fff xxxx BBB ZZZ 345 sr ggg, hhh jjdld How can i write a macro for this? Any help would be very appreciate. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to seperate every 6th row out of a column? | Excel Discussion (Misc queries) | |||
| seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
| Seperate Data in one column into two columns? | Excel Worksheet Functions | |||
| Excel - returning column headers in a seperate column | Excel Discussion (Misc queries) | |||
| how do i seperate data from one column into two seperate ones in . | Excel Discussion (Misc queries) | |||
Threaded Mode
