Hi,

You can use a non-macro solution:

1. In column D enter the formula =A1&B1&C1
2. Copy this formula down as far a necessary
3. Select all the formulas and choose Copy.
4. Click on C1 and choose Edit, Paste Special, Values.
--
Cheers,
Shane Devenshire


"NeedHelp" wrote:

I have three columns of data similar to:
A B C
a 1a melon
b 2b lettuce

I want column c to read a1amelon
that much is easy but I want this to apply to every row to the end of the data
so that it reads like:

a 1a a1amelon
b 2b b2blettuce
etc.

Help is appreciated

--
Thanks