Merging Data

[Little Lou]

Hi there

I'm sure there's a way of doing what I want to do but can't remember how.

I'm compiling data to be transfered into a report program but the programe can't deal with any Excel Formulas so the data has to appear 'as is' so to speak.

I have 2 columns of data (roughly 1200 rows) and I need to merge the two together but i can't have the formula in the merged cell - if that makes sense.

eg. Cell A1 displays Thomas
Cell B1 displays Brown

Cell C1 needs to display Thomas Brown but not the formula of
=CONCATENATE(A1," ",B1)

The programe will only be able to comprehend Thomas Brown and not
=CONCATENATE(A1," ",B1)

Any suggestions other than me manually typing the whole lot

[martindwilson]

copy column with concatenate in it then paste back special/values

[Little Lou]

Thank you that's fabulous !

[JBeaucaire]

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

[Little Lou]

Thank you J, I've done that now.