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

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

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

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

Hi SPC Ramirez

you're welcome.

Cheers
JulieD

"SPC Ramirez" <SPC wrote in message
...
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