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
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
Related Q & A:
- How can I communicate Raspberry Pi and Arduino (in both ways) using a 10-15m distance wires?Best solution by Arduino
- How can i attach word,excel,mp3,picture files to e-mail messages in yahoo mail quickly?Best solution by Yahoo! Answers
- How can I transfer my address book from one Yahoo account to a new one?Best solution by Yahoo! Answers
- How can I sue someone living outside the U.S. that bought a business from me in Florida?Best solution by Yahoo! Answers
- How can I print wirelessly from a laptop to a printer without a router?Best solution by answers.yahoo.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
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.