Combined Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have combined cells (first name and last name) using the following formula
=A2&" "&B2 and then copied the formula in that column. It combined the first
and last name all the way down in the column but when you click on the cell
up in the bar you see the formula and not the name. How do I make it the
exact name and not the formula? I have forgotten how to do this and it is
driving me crazy... anyone
 
Highlight the column with the formula in, click <copy>, then click Edit
| Paste Special | Values (check) OK then <Esc> or <Enter>.

Hope this helps.

Pete
 
Highlight the range of cells containing the formulas, then Right-click > Copy
PasteSpecial > Values > OK...........the formulas will disappear and only
Click to expand...
the names will remain and will show up in the upper bar.....

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Combine First and Last Name colums to create thrid column of full 3
Vlookup and return sheet name also 2
Update cell value based on name and specific date 1
Excel VBA 1
Copying formulas across columns 2
VLOOKUP 1
Combining an IF with another formula 4

Back
Top