Hi,
I want to select the state, then dependent dropdown to town and automatically prefill postcode and MMM from this. See example spreadsheet.
I also want to format mobile numbers, so that if they are entered as e.g."04666666666" it will turn into "0466 666 666" in the table so excel doesn't drop the "0" e.g. "66666666".
Thanks!
Bookmarks