Exceladd1ct
Board Regular
- Joined
- Feb 10, 2019
- Messages
- 76
I have a huge spreadsheet with thousands of values on column A.
The values have the form/mask of xxx-xx.xx or xx-xxx.xxx
I need to check what form/mask each value has and return the mask to column B.
Can anyone please point me in the right direction? I can find any excel function for this. If excel can't help, maybe there is a vba function for this?
Thank you!
The values have the form/mask of xxx-xx.xx or xx-xxx.xxx
I need to check what form/mask each value has and return the mask to column B.
Can anyone please point me in the right direction? I can find any excel function for this. If excel can't help, maybe there is a vba function for this?
Thank you!