Need to extract only words between two dashes in other cell

[hrdpgajjar]

hi,
i've a data sheet which contains value like below,

sk-1245
brd-47890
1415-bk-1246
1415-sk-125
1415-brd-2126

now i need only word between two dashes. as we can see characters btween two dashes are either 2 or 3..


so how can i get the result in another cell?


please help.

thank you,

[Punnam]

=MID(A1,FIND("-",A1)+1,LEN(A1)-FIND("-",A1,FIND("-",A1)+1)-1)
assuming that data is in cell a1 just drag it down the column
a basic function can be done more effective with substitute function also a
Punnam

[sktneer]

There are different ways to achieve this... One of them is this.....

Assuming your string is in A1, then
In B1

Please Login or Register  to view this content.

[samba_ravi]

sk-1245
brd-47890
for the above what is the answer

[sakmsb]

=MID(A1,FIND("-",A1)+1,LEN(A1)-FIND("-",A1,FIND("-",A1)+1)-1)
assuming that data is in cell a1 just drag it down the column
a basic function can be done more effective with substitute function also a
Punnam

it is giving

bk-
sk
brd

seems it needs tweaking...

[samba_ravi]

=IFERROR(MID(A1,SEARCH("-*-",A1)+1,SEARCH("-",SUBSTITUTE(A1,"-","^",1))-SEARCH("-*-",A1)-1),"")
try this

[Punnam]

@ sakmsb,

Yes it is happening i have modified a bit ( thank for spotting it)
=MID(A1,FIND("-",A1)+1,FIND("-",A1,FIND("-",A1)+1)-FIND("-",A1)-1)
and it working fine i think

Punnam

[sakmsb]

@ sakmsb,

Yes it is happening i have modified a bit ( thank for spotting it)
=MID(A1,FIND("-",A1)+1,FIND("-",A1,FIND("-",A1)+1)-FIND("-",A1)-1)
and it working fine i think

Punnam

Yes, it is fine now.

So for OP i have just added Iferror part.

@OP, use this:- =IFERROR(MID(A1,FIND("-",A1)+1,FIND("-",A1,FIND("-",A1)+1)-FIND("-",A1)-1),"")