Hello!
I have a list of text like:
2018 1234 MIAU ABCD XPTO123 XXX
2018 5687 MIAU AB XPTEXT TEXT TEXT
2018 1278 MIAU AD TEXT 1234 TEXT 45678
2018 00217 MIAU ABCDE TEXT 12345 1231 TEXT XPTO
2018 78424 MIAU AD XPTO
2018 78424 MIAU ABCDEF TEXT TEXT TEXT
2018 78424 MIAU AD Limpa Suja Mata Mata
I would like to know if there are any way to do with VBA to show only the first word after "MIAU"
Thanks
Try this formula
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
If it must be VBA something like this ought to work too... how well it works depends on how good the sample of data is:
Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Thanks for the help!
Workds very good
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks