Excel Replace Query

[Old_Geezer]

Hopefully as easy one for the Excel savvy.

I have a reasonably tall column in my spreadsheet which contains calculations of the type =b10+a11 which need to be retained.
It also contains some blank cells.

I've decided I'd like it better formatted so want to add bits to near the start and end to get, for example, =TRUNC(b10+a11,3) in order to get rid of superfluous decimal points. (Well it'll look nicer.)

Having problems visualising how to search & replace the whole column in one fell swoop.

Thought I had a solution when I posted it into a text editor, then right at the end I realised the caculations had been replaced by values :-( So much for that idea.

Anyone have any simple solution ?

[ToraToraTora]

do the first one then grab the bottom right hand corner(hover over the corner until the pointer changes to a +) and drag down to the bottom of the column.

[Old_Geezer]

Hadn't thought of that. It may work with a tidy up afterwards. I'll give it a try, cheers.

[Old_Geezer]

Just tried. Worked fine. Heck of a lot of cells to return to blank in order to reset the different blocks of data, but 'tis done. Thanks.