Mass removing parts of a forumla

[RyanUK]

Hi all,

Using MS Excel 2007 - I have a large number of rows and columns in spreadsheets that currently have a forumla such as:

=SUBSTITUTE(AV4,"{NAME}",LOWER($A4))

Is it possible to mass remove all of the the LOWER functions through out the spreadsheet but leave in the $A4 so it reads

=SUBSTITUTE(AV4,"{NAME}",$A4)

Thanks in advance

Ryan

 

[Trevor G]

If you have replaced the formula in a cell as indicated then double click the AutoFill handle at the bottom right of the cell and it will fill through the rows to the end of your table.

 

[JackDanIce]

Quickest way I think is press CTRL+H (find and replace) and then

Find what: LOWER($
Replace with: ($

And then click on Replace All

 

[kidwispa]

Hi Ryan,

You can do this by using find and replace.

Highlight the selection, press Ctrl+H

Find what = LOWER

Replace with = leave blank

That should do the job

 

[RyanUK]

Ah thank you! I wasn't sure if I would have to remove the brackets too but it looks like I don't so that is much easier.

Thanks