PDA

View Full Version : Capture the Certain text in excel



da_phat
12-08-2008, 08:32 PM
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
12-08-2008, 11:47 PM
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
12-08-2008, 11:50 PM
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...