1) Copy the data and Paste into Word
2) Convert the resulting table to text (Table>Convert...)
3) Find/Replace the tabs ( use the special characters ^t in the Find What
box for a tab) with nothing
4) Then copy the data and paste it back into Excel.
Or, use the following formula:
=A1 & " " & B1
This assumes the data you want to merge is in Columns A and B.
Put the formula in a blank column, then "Fill Down" by dragging the fill
handle so Excel writes a formula into each cell concatenating the contents
of each row in the two source columns.
Then copy the new column, and use Edit>Paste Special> Values to paste the
results into one of the two source columns.
Cheers
Version: 2008 Processor: Power PC I have a (long)column of numbers and a
column of names. I need to merge them so the numbers are in the cell before
each name. Can I do this without doing each cell individually?
THanks! Need help quick.
--
The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!
John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:
[email protected]