Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
An action which I do mostly by hand, row for row, perhaps is possible to do automaticly. In a sheet column A till Z, is in column F in some cases text registered with a 'slash' in between if more then one text occur in the specific cell. If Cell F contains more textfields, and then there also slashes, then I split it out in identical copied rows, with only in column F the text as standalone separated part. The basic row stays as it is, only if there are for example 3 slashes in column F then I insert 3 rows below this basic row, copy the complete row, and fill in cell F only that part of the text. If there are no slashes then no copy action required. For example. Row.....ColumnF 2.......aa/bb/cc 3.......dd/ee 4.......ff 5.......gg/hh/ii 6.......jj results then in Row1....ColumnF 2.......aa/bb/cc 3.......aa 4.......bb 5.......cc 6.......dd/ee 7.......dd 8.......ee 9.......ff 10......gg/hh/ii 11......gg 12......hh 13......ii 14......jj If somebody like to solve :) Then I can stop doing it by hand. regards, Johan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to split one cell into multiple rows? | Excel Discussion (Misc queries) | |||
HELP! Split cell contents to new rows | Excel Discussion (Misc queries) | |||
Need to split a cell into multiple rows | Excel Programming | |||
Copy pasting Rows, but need to Delete any Shapes/Pictures that are within copied rows | Excel Programming | |||
Split Cell Into Seperate Rows | Excel Programming |