#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Formulas

I'm thinking the chances of this are slim to none, but here goes...

I have 4 columns in an excel spreadsheet. The first 3 contain values. The
last column I have written a concatenation formula to combine the first 3
columns. Is there a way to lock in the actual data that is in column 4 so
that I can delete columns 1-3 when its complete and not get the REF# error.
I understand that the formula is reading columns 1-3 in order to know what to
do, but I want to somehow convert the cell from the formula to the actual
concatenated value...so that the reference cells can be deleted.

Does anyone know if this is possible?
  #2   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default Formulas

copy / paste special / select Values

"Dreyah" wrote:

I'm thinking the chances of this are slim to none, but here goes...

I have 4 columns in an excel spreadsheet. The first 3 contain values. The
last column I have written a concatenation formula to combine the first 3
columns. Is there a way to lock in the actual data that is in column 4 so
that I can delete columns 1-3 when its complete and not get the REF# error.
I understand that the formula is reading columns 1-3 in order to know what to
do, but I want to somehow convert the cell from the formula to the actual
concatenated value...so that the reference cells can be deleted.

Does anyone know if this is possible?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Formulas

Thank you SO much. You have no idea how much time you just saved me!!

"dlw" wrote:

copy / paste special / select Values

"Dreyah" wrote:

I'm thinking the chances of this are slim to none, but here goes...

I have 4 columns in an excel spreadsheet. The first 3 contain values. The
last column I have written a concatenation formula to combine the first 3
columns. Is there a way to lock in the actual data that is in column 4 so
that I can delete columns 1-3 when its complete and not get the REF# error.
I understand that the formula is reading columns 1-3 in order to know what to
do, but I want to somehow convert the cell from the formula to the actual
concatenated value...so that the reference cells can be deleted.

Does anyone know if this is possible?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP Sherberg Excel Worksheet Functions 4 September 11th 07 01:34 AM
lookup formulas dependent upon lookup formulas Skibee Excel Worksheet Functions 1 July 20th 07 01:06 PM
automatically copy formulas down columns or copy formulas all the HowlingBlue Excel Worksheet Functions 1 March 17th 07 12:11 AM
Formulas not evaluated, Formulas treated as strings Bob Sullentrup Excel Discussion (Misc queries) 0 November 27th 06 09:01 PM
formulas for changing formulas? creativeops Excel Discussion (Misc queries) 4 January 26th 06 04:07 AM


All times are GMT +1. The time now is 03:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"