Excel values mask

[Exceladd1ct]

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!

 

[CyrusTheVirus]

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:

=IF(MID(A1,4,1)="-","xxx-xx.xx","xx-xxx.xxx")

 

[Exceladd1ct]

Thank you. This is a smart way to achieve what I need. It works very well.

 

[CyrusTheVirus]

You're welcome.