How to get 3 character before and after dash

[ziyan89]

Hi,

I have these data "SUSAR No. 197-217"

I need to get result 197 and 217
which is 3 character before "-" and 3 character after "-". May I know of a formulae?

[Special-K]

Your limited example data implies, there will always be 3 characters before AND after. I suspect not.
Supply some more example data please.

[ziyan89]

Hi yes it is always 3 characters

[AlKey]

I assume that 197 and 217 will be put in two separate cells.
Enter formula in B1 and drag formula across to C1

Please Login or Register  to view this content.

v	A	B	C
1	SUSAR No. 197-217	197	217

[Special-K]

Assuming there's only ever one hyphen in the string

=MID(A1,FIND("-",A1)-3,3)
and
=MID(A1,FIND("-",A1)+1,3)