'Orns Posted March 3, 2015 Report Share Posted March 3, 2015 Need to rid a range of sums, over multi sheets of the $ anchor in sums....anyone know a quick way of doing this?? For example - multi sheets are Jan to Dec, and the sums would all be in the same cell on sheet, so can group the separate tabs together, just can't work out a quick way of editing them out Link to comment Share on other sites More sharing options...
BRISTOL86 Posted March 3, 2015 Report Share Posted March 3, 2015 Ctrl+H (Find and replace) If you don't have any other $ signs in your workbook then that's all you need to do, so in the find box you'd have "$" and in the replace box you'd leave it blank. Then hit replace all and job's a good un (make sure you have "Workbook" rather than "Sheet" selected as the search radius). If you have other $ signs in your workbook (other than where they're used as formula anchors) then it's a bit trickier. Link to comment Share on other sites More sharing options...
Admin Ian M Posted March 3, 2015 Admin Report Share Posted March 3, 2015 If you have other $ signs in your workbook (other than where they're used as formula anchors) then it's a bit trickier. In that case just select all the cells with the $ formula anchor & then run find + replace to only affect the selected cells. Link to comment Share on other sites More sharing options...
'Orns Posted March 4, 2015 Author Report Share Posted March 4, 2015 Thanks chaps - I actually had the thought driving home if find and replace would work on this, so thanks for confirmation! Link to comment Share on other sites More sharing options...
'Orns Posted March 4, 2015 Author Report Share Posted March 4, 2015 Worked like a dream, thanks chaps Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.