How to replace a string inside of a Word Document?

MS Word Question: How can I replace empty cells in an MS Word table with a string 'N/A' (quickly)?

  • I have a rather long table of text in MS Word (It's too hard to copy it into excel due to formatting of the text). One column specifies whether the entry is applicable or not. The person who filled it out left all of the N/As blank. How can I do find & replace for empty table cells (in 1 column) and place 'N/A' if a cell is empty? I'm assuming I'll need a macro. I've done simple macros in excel before, but not in word. I'm running office 2003. Help? Thanks

  • Answer:

    In the time it would take to do a custom macro you could do a zillion cut and paste operations. Put the cursor in the first box of that column. Type in "N/A" and then highlight it. Use control-C to copy it. Now go down tot he next box and use control-V to paste it there. Keep repeating the paste in every empty box that needs it. You will find that after a box or too you can get a rhythm going so that the whole task just takes a few seconds for each insertion. It is not classy but it will get you through the repair in a minute or so.

curious1... at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

You don't have to use the find and replace funtion. Use copy and paste instead. First just type N/A into the first empty cell in specified column. Then copy contents of said cell (control + C). Then select second empty cell of specified column by clicking it and then holding shift... scroll down to last page (click and drag on scroll bar) and click on last cell of same specified column. All cells in only specified column should be selected. Then paste (control + v). The whole selected column should fill up with N/As. All specified columns on all pages in one paste keystroke. Easy.

Thomas Aeruthayan

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.