Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace data with the result of a formula
Hello,
I have a long list of names in <first <last format and want to change them to <last, <first format. I know how to do this with a fomula, but want the column with the result to have the actual text, not the formula that produces the text. The only way I've figured out is to export the result of the formula to a text file and then read it in again to replace the original column of text. Is there a better way? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace data with the result of a formula
Place your formula in a blank column B (insert if needed). Copy Column B and in Column A use Paste SpecialValues. Then Delete Column B. No formula remain. Does this work for you? Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=491439 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace data with the result of a formula
Hello Bruce,
Absolutely perfectly! Did not know about the "paste special" function. Many thanks! "swatsp0p" wrote: Place your formula in a blank column B (insert if needed). Copy Column B and in Column A use Paste SpecialValues. Then Delete Column B. No formula remain. Does this work for you? Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=491439 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace data with the result of a formula
I'm glad it worked for you. Thanks for the feedback, it is always appreciated. Cheers! -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=491439 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions |