Find and delete part of formula for multiple formulas?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings, I need some help. Is there a way I can Find all my formulas and
if they contain a certain part, have that part deleted? Example. My formula
is:

=GL(BSPEC($C4,Sample!$A$59),Sample!$B$6,Sample!$A$17,Sample!$B$2,Sample!$A$5)

and I have this in hundreds of cells in my worksheet. I need to delete the
last part ",Sample!$A$5". Can I automate this somehow using find and replace
with. Already tried creating a macro but could not get it to work properly.
Thanks in advance for any help.
Cheers.
 
did you try
FIND ,Sample!$A$5)
REPLACE WITH )

It is nice it is the last one
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup formula 1
MS word Find and Replace using Regex - Help required 0
Formula numbers and text Trying to pull a random sampling 1
One part number with several substitute numbers 16
Attn: Bob Phillips (or any expert!)... help with formula 7
Multiple Values 5
Formula help 3
Formula to Match Values 9

Back
Top