Capture the Certain text in excel

[da_phat]

Does anyone knows a code on to capture a specific text in a cell. For example i have "Townsville QLD 5400". I would like to capture the word "QLD".thx

[georgiboy]

When you say capture does that mean that QLD could sometimes be QWE and so on?

Is the part you want to capture always three letters long and in uppercase?

Do you want to put the captured word into another cell?

[GTO]

Greetings da_phat,

You'd need to be a bit more specific as to what is being looked for, such as: the literal string "QLD", or the second "word" where we could tell Excel to look for the spaces, or ???...

Hope this helps,

Mark

EDIT: Oops! My slow typin' again...