Hi,

Thank you for the answer. I greatly appreciate it.

bye
SPC Ramirez

"JulieD" wrote:

Hi

In A1 type
=D1 & " " & B1 & " " & C1
fill down as needed
then select column A and copy it
click on A1, choose edit / paste special - choose Values and click OK

the formulas will be replaced with the values.

Cheers
JulieD

"SPC Ramirez" <SPC wrote in message
...
I'm trying to get three cells to join without the formula.
example:
B1 - Smith
C1 - John
D1 - Mr

A1 - Mr Smith John

how can I make A1 equal that value without using a formula or with using a
formula and then just keeping the value and getting rid of the formula.

Any help or advice will be greatly appreciated
Thanks in advance