Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Divide Cell Across Rows
Hello,
For example, I have 3 cells across by one row down and the first two contain data that is separated by Ctrl + Enter: Column: A B D Row: 1 Dog X 100 1 Cat Y 1 Mouse Z I am trying to fnd a way to split the data across 3 separate rows, in this example, as such: Column: A B C Row: 1 Dog X 100 2 Cat Y 100 3 Mouse Z 100 The data may sometimes be separated by another character, such as ; or , In an ideal world, I would love for the user to input which character or characters are the dividing character, but if this is too difficult, then I could simply provide different macros for different characters. Also, I don't want specific columns to be referred to, as the layout and column position of these items may change from file to file. Basically, for them to select the column(s) they wish to divide. Any help at all in this problem would be greatly appreciated. Thank you. -- Thanks! Dee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i divide an xl sht into 2 sections with diff placed rows | Excel Discussion (Misc queries) | |||
To take the cells in the same row and divide them in rows | Excel Discussion (Misc queries) | |||
Looking for a formula that will divide a column & rows by 2 | Excel Worksheet Functions | |||
I Need to divide all cells in rows 2 and 3 by 100 | Excel Discussion (Misc queries) | |||
divide multiline text cell across several rows | Excel Programming |