You will need Excel and Word for this.
Your data is all in Column A.
Go to the last not empty cell in A
This is how to do it :
You go to cell B1
Hit Ctrl + Down arrow, that getsyou to the bottom of B.
Move one cell left.
That's the bottom of Column A.
Now hit Ctrl + Up Arrow
Now you're on the last not empty cell of A
Now move one cell right
Key in a zero to this cell
Now hit Ctrl + Up arrow
Now you're back to B1
In B1, key in this formula if(A1="";"XYZ";A1)
That means
if the cell on the left is empty write "XYZ"
otherwise just copy the contents of the cell on the left.
Now you have to copy this formula all the way down to the zero that we left
sitting there in B.
Easy. Don't use the mouse.
With the cursor still in B1
Press Shift + Ctrl + Down arrow.
This will select all the way down to the zero.
Now relase the keys and then
Press Ctrl + D.
This will Copy the formula all the way down.
Release the keys.
Now press Ctrl + C to copy all that into the Clipboard.
if you are in XL 2003 --- Now take the mouse and go to the menu, choose
Edit, paste Special ,
Click on Values, then OK
if you are in XL 2007 --- Now take the mouse and go to the Home menu,
click on the little arrow under the
word paste Paste, the Paste Values
Now the Column B contains all that was in Column A plus "XYZ" where A has
empty cells.
No formula, just data.
Reselect all the data in B
Then Ctrl + C to copy it all into the clipboard.
Open Word.
Gto the menu , edit, paste as plain text
You should have the column of data.
Now press the little Icon with the paragraph character that lets you see the
hidden characters that Word uses.
You should see a paragraph character at the end of each line.
That's OK.
Now, we are going to replace each one onf these paragraph character into a
tabulation.
In Word language this "paragraph character " is written "^p", without the
quotes.
In Word language this "tabulation character " is written "^t", without the
quotes.
press Ctrl + H.
Depending on what version of Word you're using the Dialogue box is
different.
Find what ? Key in "^p" without the quotes.
Replace with ? Key in "^t" without the quotes.
Or you can use the More Button, then the Special button,
to Find the "paragraph character" option and then again
to Replace with the tabulation character.
When you click OK Word will do the replace.
This may take some time.
Your text will look crazy and useless but don't worry.
When it's finished, save the document.
This will free up dome memory.
Press Ctrl + H again.
Now Find the occurences of XYZ and
replace them with ....... the paragraph character !!
Now the text should look a lot better.
Save the document as plain text.
Open it with Excel.
Happy ?
Merge.
HTH
Zumble.
