LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 106
Default Macro to grab "inbetween words" from a text

Group members and MVP's,

I have a text in range("A1"). Let us assume that the text is C:
\012245\Aeroplane\

I would like to have a macro that grabs the word "plane" from the text
C:\012245\Aeroplane\

Recording a macro doesnt seem to help in this case.

Thanks!
-T

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I alphabetize data excluding words like "a" and "the"? Faith Excel Discussion (Misc queries) 6 November 11th 09 05:50 PM
Would I use "Lookup" to pick names for a Christmas grab bag Doebaby Excel Worksheet Functions 13 November 7th 07 11:20 PM
VLOOKUP won't generate correct response for "inbetween" values NavyPianoMan Excel Discussion (Misc queries) 9 August 28th 07 02:28 PM
certain words "CONTAINS" in an free text cell........... Beverly C Excel Discussion (Misc queries) 2 February 6th 07 02:51 PM
Sending macro based e-mail with built-in "Heading" and "Text" Prabha Excel Programming 3 January 17th 05 02:11 PM


All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"