Anyone knows if it is possible to apply Search and Replace to part of a formula?

**faundezp** · 06-15-2007, 02:28 AM

I need to remove the first part of a formula in thousands of cells. This first
part of the formula is the same in all the cells.

Anyone knows if it is possible to apply Search and Replace to part of a formula? It seems that Search can find anything inside a formula, but then Replace only allows to change the contents of all the cell.

Any ideas ?

Many thanks !!!

**VBA Noob** · 06-15-2007, 02:34 AM

See link

http://www.bettersolutions.com/excel...A318211612.htm

VBA Noob

**faundezp** · 06-15-2007, 02:44 AM

That will only allow to replace all the content of the cell. I need to replace only the first part of it.

Thanks again.

**VBA Noob** · 06-15-2007, 03:26 AM

E.g

In the Find box enter the full formula

=SUM(A1:A11)

in the replace box enter the new formula

=SUM(A4:A11)

or

just find

(A1:

and replace

(A4:

HTH

VBA Noob

**faundezp** · 06-15-2007, 03:50 AM

Many thanks but:

Your first suggestion is too difficult as the formulas are thousands !!
Your second suggestion will replace the whole contents of the formula with (A4: and will delete the rest of the formula !!!

Thankyou !!!!!!!!!!

Anyone knows if it is possible to apply Search and Replace to part of a formula?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Anyone knows if it is possible to apply Search and Replace to part of a formula?

That will only allow to replace all the content of the cell. I need to replace only t

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions