LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #21   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default Extract two letters

Just shows how much younger you are compared to some of us.<bg
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Dave Peterson" wrote in message
...
I remember the Bob Barker version.

Ragdyer wrote:

How many around here are old enough to remember how it got that name ...
from a popular radio show in the early '50's.

I believe Ralph Edwards was the host and he got them to change it as a
publicity stunt.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Peo Sjoblom" wrote in message
...
Interesting, that is what we call it in Sweden (translated of course), I
always thought you "Yanks" called it "Truth or Dare"

Maybe it was too hard to say? <vbg?



--
Regards,

Peo Sjoblom




"Dave Peterson" wrote in message
...
I liked this one:
http://maps.google.com/maps?q=Truth+...map& ct=title



Peo Sjoblom wrote:

http://www.floydpinkerton.net/fun/citynames.html

nothing really to do with this thread except that US city names can
obviously be called anything,
I like Intercourse, PA

another one I remember with regards to this thread

Avon By The Sea

Peo

"Ragdyer" wrote in message
...
It comes down to how many are there of those, as compared to how
many
contain numbers as Ron mentioned.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may
benefit !
---------------------------------------------------------------------------
"Dave Peterson" wrote in message
...
Until you get to King of Prussia, Pa.

Ragdyer wrote:

Does this work for you:

=MID(A1,SEARCH(" ?? ",A1)+1,2)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may
benefit
!
---------------------------------------------------------------------------
"bm" wrote in message
...
Trying to extract two letters, the state to be more specific in
cells
that
have varying lenghts and number of spaces. Examples:
CEDAR RAPIDS IA 52404 USA
DANVILLE IL 61834 USA
FARGO ND 58102 USA
DES PLAINES IL 60016 USA
WOOD DALE IL 60191-1960 USA
So the only two letter combo between two spaces...
I need the states pulled out of these. Example
IA
IL
ND
IL
IL
Thanks

--

Dave Peterson



--

Dave Peterson




--

Dave Peterson


 
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
Extract letters from a cell Lupe Excel Worksheet Functions 2 November 22nd 06 06:33 PM
How do change a column of data in capitol letters to small letters Barb P. Excel Discussion (Misc queries) 6 November 15th 06 06:17 PM
Extract bold letters in a cell hbamse Excel Worksheet Functions 1 March 21st 06 08:35 AM
Extract bold letters in a cell Stefi Excel Worksheet Functions 0 March 20th 06 02:51 PM
Extract Unique Values, Then Extract Again to Remove Suffixes Karl Burrows Excel Discussion (Misc queries) 23 June 25th 05 10:37 PM


All times are GMT +1. The time now is 03:09 AM.

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"