Hi,
I'm looking to make an excel formula based on the following logic. Preferably not scripting etc. I am trying to validate numbers for a phone dialer.
In column (a) I have phone numbers (no special characters)
in column (b) I have the correct country code for that number's country
IF (a) starts with 0, drop the 0. Lets call that (a-0)
IF (a-0) starts with (b), print (a-0)
ELSE print (b)&(a-0)
Bookmarks