Combining Text/Concatenate question

  • Thread starter Thread starter Alison
  • Start date Start date
A

Alison

I have a worksheet with three columns for an address that
I need to combine. For example, I have "1600" in one
column, "Pennsylvania Ave." in the second, and "Oval
Office" in the third. I need to combine these three
columns into one so that it reads "1600 Pennsylvania
Ave., Oval Office."

I've tried the Concatenate function, but then I can't
delete the original columns without getting the #REF
message. Is there a way I can just merge the three
columns into one? Or to use Concatenate and then delete
the original columns? I need to use this for a mailing,
so that's why it's important to delete the extra colums.

TIA for your help.
 
Hi Alison
after concatenating your columns using CONCATENATE (or with the
formula: =A1 & " " & B1 & " " C1)
try the following:
- copy the new column (CTRL+C)
- goto 'Edit - Paste Special' and insert the copied data as 'Value'.

This will 'replace' the formulas with the formula results. Afgter that
you can delete the other columns A-C

Frank
 
Back
Top