Extract digits from string

[chunu]

Hi,
I want to extract 15 digits from right (including dash) from cell, but if cell contains less than 15 characters ignore.
Thanks

office 2013

abb.xls
	A	B
1	Data	Required result
2	G)2023 l
3	e 202301:t
4	128020201
5	¡tsJ61 97201-1760694-3	97201-1760694-3
6	:5--51
7	z0G19| 87201-8189188-9	87201-8189188-9
8	z5S67
9	zbSslJ41
10	bJ35
11	0sJ44
12	240
13	17201-5796810-3	17201-5796810-3
14	47201-2204445-3	47201-2204445-3
15	87201-9363219-7	87201-9363219-7
16	67201-5912222-1	67201-5912222-1
Sheet3

 

[alansidman]

Book6
	A	B	C
12	Data	Required result	Formula
13	G)2023 l
14	e 202301:t
15	128020201
16	¡tsJ61 97201-1760694-3	97201-1760694-3	97201-1760694-3
17	:5--51
18	z0G19| 87201-8189188-9	87201-8189188-9	87201-8189188-9
19	z5S67
20	zbSslJ41
21	bJ35
22	0sJ44
23	240
24	17201-5796810-3	17201-5796810-3	17201-5796810-3
25	47201-2204445-3	47201-2204445-3	47201-2204445-3
26	87201-9363219-7	87201-9363219-7	87201-9363219-7
27	67201-5912222-1	67201-5912222-1	67201-5912222-1
Sheet1

Cell Formulas
Range	Formula
C13:C27	C13	=IF(LEN(A13)<15,"",RIGHT(A13,15))

 

[chunu]

Book6
	A	B	C
12	Data	Required result	Formula
13	G)2023 l
14	e 202301:t
15	128020201
16	¡tsJ61 97201-1760694-3	97201-1760694-3	97201-1760694-3
17	:5--51
18	z0G19| 87201-8189188-9	87201-8189188-9	87201-8189188-9
19	z5S67
20	zbSslJ41
21	bJ35
22	0sJ44
23	240
24	17201-5796810-3	17201-5796810-3	17201-5796810-3
25	47201-2204445-3	47201-2204445-3	47201-2204445-3
26	87201-9363219-7	87201-9363219-7	87201-9363219-7
27	67201-5912222-1	67201-5912222-1	67201-5912222-1
Sheet1

Cell Formulas
Range	Formula
C13:C27	C13	=IF(LEN(A13)<15,"",RIGHT(A13,15))

Thank you so much

 

[smozgur]

Thank you so much

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.