 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2006New Problem: #REF!
Okay, I succeeded in combining the first and last names from two separate columns into a new third column. However, when I try to delete the unwanted first and last name columns, all the data in the Full Name column is replaced with #REF! What can I do? Is there any way I can unlink these three columns? Select whole 3rd column Edit>Copy Edit>Paste special , check Values HTH -- AP > Okay, I succeeded in combining the first and last names from two separate > columns into a new third column. However, when I try to delete the [quoted text clipped - 4 lines] > > What can I do? Is there any way I can unlink these three columns? Yeah.. copy the third Column and paste special > value into a fourth column  SignatureBearacade Just paste special in place. Why add another column? Gord Dibben MS Excel MVP >Yeah.. copy the third Column and paste special > value into a fourth >column Hey folks, Paste Special is not working for me. I select the new column C created with data from column A and B. I select edit>copy>paste special. Then when I try to delete columns A and B, column C reverts to #REF! > Just paste special in place. > [quoted text clipped - 4 lines] > >Yeah.. copy the third Column and paste special > value into a fourth > >column It should work. Select all of the cells in column C where you combined them with the formula. Use copy at that point. Without unselecting them, simply use Edit | Paste Special and make sure [Values] is selected and press OK. You should then be able to delete columns A and B. I think we are all presuming you used a formula something like this in column C: =A1 & " " & B1 or =B1 & ", " & A1 If you used something else, please copy the formula and show it to us here. > Hey folks, > [quoted text clipped - 10 lines] > > >Yeah.. copy the third Column and paste special > value into a fourth > > >column |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.