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?
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...
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.