function result noob question

  • Thread starter Thread starter philtyler
  • Start date Start date
P

philtyler

I inserted a function to merge the text in 2 columns into one column
Now I want the new cell to contain the result as text and not as th
formula.

Ex:

column A column B column C

Phil Tyler PhilTyler

I want the cell in column C to be PhilTyler not the formula column
plus column B

remove the function keep thee result in the cel
 
Hi Phil,

With your formula cells selected, try:

Edit Copy | Edit Paste Special | Check Values | OK | Esc
 
Copy then Paste Special(in place)>Values>OK>Esc.

Also, if you wanted a space between Phil and Tyler as in Phil Tyler use

=A1 & " " & B1

Gord Dibben Excel MVP
 
Back
Top