View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Extract two letters

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