how do i keep a value and get rid of a formula?

[Guest]

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

 

[JulieD]

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

 

[Guest]

Hi,

Thank you for the answer. I greatly appreciate it.

bye
SPC Ramirez

 

[JulieD]

Hi SPC Ramirez

you're welcome.

Cheers
JulieD

Hi,

Thank you for the answer. I greatly appreciate it.

bye
SPC Ramirez