Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS Excel and Empty Cells

Status
Not open for further replies.
esengul

esengul

Instructor
Dec 9, 2004
59
US
I have a table which is importing from MS Access. That table has empty cells in it. What i want to do is fill those empty cells with "na" word automatically. I don't know how i can do this.
Thanks in advance
E.
 
Sort by date Sort by votes
Have you tried to play with the macrorecorder when doing a Search/Replace on your data ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
We have a rule in this forum. You need to SEARCH for KEYWORDS first...then then come back.

We managed to kick somebody out of the forum for misbehaving...

(have you really?)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
1K
strongm
strongm
Kymenglish
  • Locked
  • Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
588
strongm
strongm
Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
1K
remeng
remeng
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
2K
remeng
remeng
feipezi
  • Locked
  • Question
How to pull data from MS Access DB and place on an Excel spreadsheet with WHERE clause? 2
Replies
10
Views
785
feipezi
feipezi

Part and Inventory Search

Sponsor

Back
Top