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

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

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
---

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
---