i have excel file with the data of customer, but if the cell is blanks i need to put in the word "N/A", how to set the formula for it.
Name Tel No Address Ref
Jerry N/A 11, Garden 22
Amy 1234567 N/A 25
Sam 1235678 1, Garden 22
i have excel file with the data of customer, but if the cell is blanks i need to put in the word "N/A", how to set the formula for it.
Name Tel No Address Ref
Jerry N/A 11, Garden 22
Amy 1234567 N/A 25
Sam 1235678 1, Garden 22
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks