| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to split the contents in a single cell separated by "," intonext cell in that column
Hi,
I have sheet 1: column A column B columnC WR# Phase SP# Row2 60625 1-0110 60625RB1,60625NS1,60625GW1,60625BB1 Expected Output on clicking a button: column A column B columnC WR# Phase SP# Row2 60625 1-0110 60625RB1 Row3 60625NS1 Row4 60625GW1 Row5 60625BB1 Is there a way to split the contents in cell C2 separated by comma (,) and place it on next cell in column C itself? Please suggest.Thankyou. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting out Content in 1 cell (which is currently separated by"ALT-ENTER") into multiple cells | Excel Discussion (Misc queries) | |||
| Convert cell "contents" into a "comment" | Excel Discussion (Misc queries) | |||
| how to increase size of "name box" and "contents of cell " displa. | New Users to Excel | |||
| if one cell has "X" textin contents, then pull cell "Y"... | Excel Worksheet Functions | |||
| How do I split "A1B2" into "A1" and "B2" using text to column fun. | Excel Programming | |||
Threaded Mode
