Home |
Search |
Today's Posts |
#1
|
|||
|
|||
reverse concantination
can we do a reverse concantination where we take values/text that share a
common cell and break them into induvidual pieces alone in their own cells? |
#2
|
|||
|
|||
You can use the left, right and mid functions to pull apart the cell.
"john mcmichael" wrote: can we do a reverse concantination where we take values/text that share a common cell and break them into induvidual pieces alone in their own cells? |
#3
|
|||
|
|||
You can also use the Data-'Text to columns' feature. In this case every
record would have to be separated by a common character, like a comma. You can choose Delimited-comma in this case. -- Regards, Dave "john mcmichael" wrote: can we do a reverse concantination where we take values/text that share a common cell and break them into induvidual pieces alone in their own cells? |
#4
|
|||
|
|||
You can use
<Data <TextToColumns to perform separations as long as there's something common within the data. Post back with encompassing examples. -- Regards, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "john mcmichael" wrote in message ... can we do a reverse concantination where we take values/text that share a common cell and break them into induvidual pieces alone in their own cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Reverse Contents in an Excel cell (Text or a Number) | Excel Worksheet Functions | |||
Reverse Conditional Formating | Excel Discussion (Misc queries) | |||
Printing same table on reverse side of all pages. | Excel Discussion (Misc queries) | |||
Reverse the sign of a number in a cell | Excel Worksheet Functions | |||
How 2 reverse order of columns | Excel Discussion (Misc queries) |