Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to Merge cells and erase original - 9KB Attach
Test on a copy of your data.
for i = 1 to 300 step 3 cells(i,1).Value = cells(i,1).Value & ", " & cells(i+1).Value _ & ", " & cells(i + 2).Value cells(i+1,1).Resize(2,1).ClearContents Next Range("A1:A300").SpecialCells(xlBlanks).Entirerow. Delete -- Regards, Tom Ogilvy "RT" wrote in message ... I have to get a spreadsheet setup so I can import into Access. Most of what would be a row in Access contains several rows that need to be merged. I can't concencate because I need to erase my original work. This little pic should explain all: RRT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Erase same content in all cells in Excel | Excel Discussion (Misc queries) | |||
Erase same content in all cells in Excel | Excel Discussion (Misc queries) | |||
how do I merge cells into one then delete the original cells? | Excel Worksheet Functions | |||
can i attach the same comment to different cells | Excel Discussion (Misc queries) | |||
How do I attach an excel document to a word one for mail merge? | Excel Discussion (Misc queries) |