Excel values mask

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!
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Welcome to the forums, not sure if this will work for you, but assuming your data starts in A1, then try the below. Wasn't exactly sure what you are trying to do, so if this doesn't do the trick, then please reply with an example of your data.

A1:
Code:
=IF(MID(A1,4,1)="-","xxx-xx.xx","xx-xxx.xxx")
 
Upvote 0
Solution

Forum statistics

Threads
1,213,532
Messages
6,114,177
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top