making a column of formuls constant

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

Guest

If A1 = James and B1 = Earl and C1 = Jones,
I can use a formula to have D1 = "Jones, James Earl"

But is there any way to make this a constant afterward?
I'd like to copy this column or fields from it outside
this sheet, but the references are all internal?

How can I say, "Now that you know the value, freeze it that way?"
 
When you copy, use Paste Special and select Values

This will copy the formula results
 
See your last post!

If A1 = James and B1 = Earl and C1 = Jones,
I can use a formula to have D1 = "Jones, James Earl"

But is there any way to make this a constant afterward?
I'd like to copy this column or fields from it outside
this sheet, but the references are all internal?

How can I say, "Now that you know the value, freeze it that way?"
 
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

making calculated fields constant. 1
making variables constant 1
Merging cells and formats 8
Keeping the format of a date 5
Concantenate which keeps bold of some parts. 5
split range address into individual cell addresses 4
Seperate cell string into individual cells 2
Baffeling IF statement 7

Back
Top