How To replace this formula:

[jamiguel77]

hi friend i have Excel in spanish language:

i have this formula:

=TRUNCAR(BB5721/N5721,4)

and have so so 2000 rows.. (intermediate have other formulas) ...

i want replace by: =TRUNCAR(BB5721/U5721,4)

note i cant write it in first cell and copy to all rows, because i have intermediate titles, etc....

i try: select entire column, go to replace text and try: replace /N by /U but cant.....

any advice?

Thanks

 

[MARK858]

Are you sure that the "match entire cell contents" checkbox isn't checked and that it is set to look in formulas not values when you do the replace?

 

[jamiguel77]

hi thanks for answer....

https://imgur.com/a/iSDOO <--- yes setting formulas and see the image...

pls

 

[MARK858]

But you have the "match entire cell contents" checkbox checked. Uncheck it! as I already said to do.

 

[jamiguel77]

Yes you are right.

Thanks.

Worked

 

[MARK858]

You're welcome