help about function

L

lunar_star

i have my data in A3:A7

HD-01-01
SP-126-01
HD-02-05
CD-80-04
GD-1000-01

and B3:B7
10000
20000
30000
40000
50000

i want take any char between -*-
 
B

Barb Reinhardt

=LEFT(RIGHT(A3,LEN(A3)-SEARCH("-",A3)),SEARCH("-",RIGHT(A3,LEN(A3)-SEARCH("-",A3)))-1)
 
Top