LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Tom
 
Posts: n/a
Default Need to find the 1st two characters of the 1st two words

Does anyone know how to come up w/ a smart function that will exctract the
first 2 letters of the first 2 words from a string.

For instance, I may have the following data in a column:
Alpha Bravo Zulu Yankee
Delta Kilo
Mike Tango Papa

I'd like to have the 4 characters strung together, such as:
- ALBR
- DEKI
- MITA

Now, the following would be a BIG PLUS!!! Let's say I had a 4th record such
as "Mke Tango Yankee". In this case, I would have MITA twice since the 1st
two words are the same (3rd and 4th record). Is there now a chance to take
the 3rd word for the example "duplicate value"? So, I'd come up with:

- ALBR
- DEKI
- MITA
- MIYA

Thanks,
Tom


 
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
Edit + Find Mindy Excel Discussion (Misc queries) 2 April 8th 05 09:49 PM
find a cells from a range of cell kelvintaycc Excel Worksheet Functions 2 April 2nd 05 07:20 PM
Using the Find tool in EXCEL TK Excel Worksheet Functions 2 February 11th 05 07:51 PM
Excel has a "Find Next" command but no "Find Previous" command. Michael Fitzpatrick Excel Discussion (Misc queries) 2 January 10th 05 11:45 PM
VB Find and Replace Bony_Pony Excel Worksheet Functions 10 December 6th 04 05:45 PM


All times are GMT +1. The time now is 05:36 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"