Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA to merge cells
The format that another application spits out is one that I would like to
make user friendly. Here is an example of what I am looking at: WELL: 5122110000 3096971.9998 PICK: GRETA **Each line of data is in one cell In my normal file I have anywhere between 400 to 2000 rows of data. I would like something that will take the lines that have "PICK:" and place all that information on the row above it and paste that line of data after the end of the data in the row "WELL:" So what this line would look like would be: WELL: 5122110000 3096971.9998 PICK: GRETA When it puts the line with "PICK:" it would be great if there was a space between the last value in the line with the "WELL:" and the P in "PICK:" Thanks for the help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA to merge cells
So you want all that stuff in a single cell?
If yes, then put this in B1: =A1&" "&A2 Put this in B2: =na() Select B1:B2 and drag down as far as you need. Select column B Edit|Copy Edit|Paste special|Values With column B still selected Edit|Goto (or hit F5)|Special|check Constants and errors (uncheck the rest) Rightclick on any of those errors Delete|shift cells up James wrote: The format that another application spits out is one that I would like to make user friendly. Here is an example of what I am looking at: WELL: 5122110000 3096971.9998 PICK: GRETA **Each line of data is in one cell In my normal file I have anywhere between 400 to 2000 rows of data. I would like something that will take the lines that have "PICK:" and place all that information on the row above it and paste that line of data after the end of the data in the row "WELL:" So what this line would look like would be: WELL: 5122110000 3096971.9998 PICK: GRETA When it puts the line with "PICK:" it would be great if there was a space between the last value in the line with the "WELL:" and the P in "PICK:" Thanks for the help -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically merge mulitiple cells to one cells | Excel Worksheet Functions | |||
how do I merge cells into one then delete the original cells? | Excel Worksheet Functions | |||
Merge of cells | Excel Worksheet Functions | |||
Merge Two Cells | Excel Discussion (Misc queries) | |||
How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) |