LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default Convert Formula Results to Absolute

I merged First Name and Last Name columns to a Full Name column with a formula. I want to copy/paste the Full Name column to another spreadsheet without having to reference the First and Last Name columns. Is there a way to eliminate the formula references in the Full Name column and retain the results?
 
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
Convert selected formula references from relative to absolute M Excel Discussion (Misc queries) 6 March 24th 10 01:09 AM
Turning forumula results as absolute numbers Edward Excel Discussion (Misc queries) 4 January 16th 08 06:22 PM
How do I convert formula result into numbers so I can sum results? Barsha Excel Discussion (Misc queries) 1 November 11th 06 07:18 PM
How can I convert a formula to it's results? ZBC2 Excel Discussion (Misc queries) 9 January 29th 06 02:17 PM
How do I convert hh:mm:ss to an absolute number (26:01:32 to 26)? Fernando Excel Discussion (Misc queries) 1 December 1st 05 05:02 PM


All times are GMT +1. The time now is 05:24 PM.

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

About Us

"It's about Microsoft Excel"