Donate SIGN UP

Excel Replace Query

Avatar Image
Old_Geezer | 08:24 Sun 06th May 2018 | Computers
3 Answers
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 ?
Gravatar

Answers

1 to 3 of 3rss feed

Avatar Image
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.
08:40 Sun 06th May 2018
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.
Question Author
Hadn't thought of that. It may work with a tidy up afterwards. I'll give it a try, cheers.
Question Author
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.

1 to 3 of 3rss feed

Do you know the answer?

Excel Replace Query

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.