Home |
Search |
Today's Posts |
#21
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extract letters from a cell | Excel Worksheet Functions | |||
How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
Extract bold letters in a cell | Excel Worksheet Functions | |||
Extract bold letters in a cell | Excel Worksheet Functions | |||
Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) |