Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Creating A Formula To Cut and Paste Text
Hi everyone. Thanks in advance for any help you may have.
I need to create a formula that searches for a specific word in a column then cut the word and paste it to another column. Of course this would be simple if it was the only word in the column, but there is other text that I would like to remain in the orginal column.. Thanks again, Mary |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Creating A Formula To Cut and Paste Text
Mary
You cannot cut and paste with a formula. Formulas can only return results to the cells in which they are written. You might get away with a "pull" formula, but then you would have to delete the original data after returning the value. You would most likely be better off using VBA. Give a description of what to find and where to transfer it to. Gord Dibben MS Excel MVP On 6 Aug 2006 18:21:05 -0700, "Mary" wrote: Hi everyone. Thanks in advance for any help you may have. I need to create a formula that searches for a specific word in a column then cut the word and paste it to another column. Of course this would be simple if it was the only word in the column, but there is other text that I would like to remain in the orginal column.. Thanks again, Mary |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Creating A Formula To Cut and Paste Text
You've a got a couple more responses in your multi-post in
..worksheet.functions. Kindly refrain from multi-posting. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Creating A Formula To Cut and Paste Text
I will... Thanks for letting me know..
Mary Max wrote: You've a got a couple more responses in your multi-post in .worksheet.functions. Kindly refrain from multi-posting. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|