ChatterBank1 min ago
Excel Replace Query
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 ?
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 ?
Answers
1 to 3 of 3
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
1 to 3 of 3
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.