Extract a delimited string

[neeraj_chow]

I have rows of strings in a column like below

Agent Name & ID: Daniel Hina - 113816

I need to extract the names which is delimited by : and -

I understand that this would require a combination of mid and find formulas but am unable to write a working formula

Can someone help

 

[VoG]

Try

=MID(A1,FIND(":",A1)+2,FIND("-",A1)-FIND(":",A1)-2)

 

[nightcrawler23]

try this

A2 = TRIM(MID(A1,FIND(":",A1,1)+1,FIND("-",A1,1)-FIND(":",A1,1)-1))

 

[sapka]

If you need it in VBA:

aa = "Agent Name & ID: Daniel Hina - 113816"
MsgBox Split(Split(aa, ":")(1), "-")(0)