Thread: how to return a text value (2-5 characters) from kolum A to B

Hi

I need help to return part of a text in kolum A to kolum B. The text is between 2-5 characters. I want it to look someting like the example below. Would be very grateful if someone can help me with this, becasue im stuck.

kolum A
MINILONG CHF A
MINILONG OLJA C
MINILONG BP C
MINILONG SP500 E

kolum B
CHF
OLJA
BP
SP500

Hi,

It looks to me like you want to extract the second "word" from a group of 3?

=LEFT(RIGHT(A1,LEN(A1)-FIND(" ",A1)),FIND(" ",RIGHT(A1,LEN(A1)-FIND(" ",A1))))