How can I check if a cell in Excel spreadsheet contains number
I have a column of addresses and I have to find those which don't contain
street numbers. Unfortunately, addresses have been input by various users
and they do not follow the same pattern so the street type, street name,
suburb are in different order and I can't use functions like LEFT, RIGHT
or MID to check if particular character is a number. The column looks like
this:
10 Willsons Drive, Manhattan
Epping, 23 Wet Rd
Longsdale St, Kingsbury
11 Link Crt, Pakenham
Is there an Excel or VBA function that can tell me if cell / string
contains numbers?
No comments:
Post a Comment