Donate SIGN UP

find and replace question

Avatar Image
ludditefreak | 12:34 Fri 10th Feb 2006 | Technology
3 Answers

I have been given a huge list of numbers to find on an excel spreadsheet and turn into bold type. is there a quick way of doing this using find and replace?

Gravatar

Answers

1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by ludditefreak. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
The fastest way would be to add filter to the top row, filter for the numbers in question, embolden them, and drop the filters
Question Author
sounds good. how do I do that? I appreciate your help!

Find and replace will also do it quite easily:


CTRL+H (or Edit > Replace) will bring up the find/replace box. Click on 'options' for advanced replace features. Type your search in the 'find what' box, leave the 'replace with' box blank, select whatever replacement formatting you require, then select 'replace all' ...


1 to 3 of 3rss feed

Do you know the answer?

find and replace question

Answer Question >>