none
Excel - Remove specific characters from entire worksheet if they are the first 2 in the cell RRS feed

  • Question

  • Hello,

    I have a very large worksheet that is used to populate a SQL database.

    I need to have the data clean before I pass it on to the owner of that database.

    The data is riddled with "na" where the supplier of the data sometimes leaves it blank, like they should, but instead sometimes puts in "na" as either "not applicable" or "information not available". 

    I just need the all "na" removed.  If I highlight the entire sheet and replace "na" with nothing then where it says "international" it will say "inertional" and I can't have that.

    I need a routine, with an on-click for a button, probably, that removes all of the "na" that comes first in the cell.

    I've seen where you can do it with individual cells, but not looping through the whole spreadsheet.

    Thank you in advance for any help I can get! 


    Gee

    Monday, March 16, 2015 2:46 PM

Answers

  • >>then where it says "international" it will say "inertional"

    Selecting the "match entire cell contents" option may give you what you want.

    • Marked as answer by GretaF Monday, March 16, 2015 3:31 PM
    Monday, March 16, 2015 3:26 PM

All replies

  • >>then where it says "international" it will say "inertional"

    Selecting the "match entire cell contents" option may give you what you want.

    • Marked as answer by GretaF Monday, March 16, 2015 3:31 PM
    Monday, March 16, 2015 3:26 PM
  • Yes!

    Perfect...thank you so much.


    Gee

    Monday, March 16, 2015 3:31 PM