extract string between two characters

[JackSmith123]

Hello All,

I need some help with extracting a particular word between two characters.

"010 - London - 01 Dock-Day"

I need to extract London from the above text string.

[JackSmith123]

I would not like to use text-to-columns...either vba or formula.

[Glenn Kennedy]

Assuming your data are in A1, use this:
=TRIM(MID(SUBSTITUTE("-"&$A1,"-",REPT(" ",125)),125*COLUMNS($A:B),125))

[JohnTopley]

If the string ALWAYS of the form with "nnn - aaaaaaaaa - nn ......" i.e text required starts in position 7 ....


=TRIM(MID(A1,7,FIND("-",A1,7)-7))

[JackSmith123]

Many thanks for your help. Both solution work.!

[Glenn Kennedy]

Thanks for the reputation added. Much appreciated.