Home |
Search |
Today's Posts |
#1
|
|||
|
|||
splitting names can't see whats going wrong (Save My Sanity )
Corrected typo's
I have a long list of words (see below) and in the next column i have this =LEFT(F1,LEN(F1)-FIND("=",F1)-2) The result is in the second list below, as you can see it's not right. No's 3, 5, 7, 8, 9, 10, 15, 18, 20, 22, 23 are in correct. Any ideas what happening here? The Hilton = Hint: Hotel Boeing = Big One General Electric = Electrical Genre MasterCard = Trader scam Lipton tea = Teapot nil Dreamworks = Mad workers Wired = Weird Victoria's Secret = Erotica Victress Random House = Around homes Virgin Air = I arriving Pillsbury = Silly burp Tower Records = Word secretor Lifesavers = Safer lives Whole Foods = Who's fooled? Princess Cruises = Scenic surprises Aeroflot = Fa loot Greyhound = Young herd Siemens = Nemesis Prudential = Real pundit Little Caesar's = Stale articles Nickelodeon = Indolence OK Learjet = Real jet Sikorsky = O! Risk sky Year Two Thousand = A year to shutdown Universal Studios = Visual is nude sort Paramount Pictures = Upon amateur script Banana Republic = Annual bribe cap ================ ================ The Hilton Boeing General Electri MasterCard Lipton te Dreamworks Wire Victoria's Secr Random Hous Virgin Ai Pillsbury Tower Record Lifesavers Whole Foods Princess Cruise Aeroflot Greyhound Siemen Prudential Little Caesar Nickelodeon Learjet Sikorsky = Year Two Thousand Universal Studios Paramount Pictures Banana Republic |
#2
|
|||
|
|||
splitting names can't see whats going wrong (Save My Sanity )
by the way it's XL2000
Corrected typo's I have a long list of words (see below) and in the next column i have this =LEFT(F1,LEN(F1)-FIND("=",F1)-2) The result is in the second list below, as you can see it's not right. No's 3, 5, 7, 8, 9, 10, 15, 18, 20, 22, 23 are in correct. Any ideas what happening here? The Hilton = Hint: Hotel Boeing = Big One General Electric = Electrical Genre MasterCard = Trader scam Lipton tea = Teapot nil Dreamworks = Mad workers Wired = Weird Victoria's Secret = Erotica Victress Random House = Around homes Virgin Air = I arriving Pillsbury = Silly burp Tower Records = Word secretor Lifesavers = Safer lives Whole Foods = Who's fooled? Princess Cruises = Scenic surprises Aeroflot = Fa loot Greyhound = Young herd Siemens = Nemesis Prudential = Real pundit Little Caesar's = Stale articles Nickelodeon = Indolence OK Learjet = Real jet Sikorsky = O! Risk sky Year Two Thousand = A year to shutdown Universal Studios = Visual is nude sort Paramount Pictures = Upon amateur script Banana Republic = Annual bribe cap ================ ================ The Hilton Boeing General Electri MasterCard Lipton te Dreamworks Wire Victoria's Secr Random Hous Virgin Ai Pillsbury Tower Record Lifesavers Whole Foods Princess Cruise Aeroflot Greyhound Siemen Prudential Little Caesar Nickelodeon Learjet Sikorsky = Year Two Thousand Universal Studios Paramount Pictures Banana Republic |
#3
|
|||
|
|||
splitting names can't see whats going wrong (Save My Sanity )
Try:
=MID(F1,1,FIND("=",F1)-2) Hope this helps Rowan workaholic wrote: Corrected typo's I have a long list of words (see below) and in the next column i have this =LEFT(F1,LEN(F1)-FIND("=",F1)-2) The result is in the second list below, as you can see it's not right. No's 3, 5, 7, 8, 9, 10, 15, 18, 20, 22, 23 are in correct. Any ideas what happening here? The Hilton = Hint: Hotel Boeing = Big One General Electric = Electrical Genre MasterCard = Trader scam Lipton tea = Teapot nil Dreamworks = Mad workers Wired = Weird Victoria's Secret = Erotica Victress Random House = Around homes Virgin Air = I arriving Pillsbury = Silly burp Tower Records = Word secretor Lifesavers = Safer lives Whole Foods = Who's fooled? Princess Cruises = Scenic surprises Aeroflot = Fa loot Greyhound = Young herd Siemens = Nemesis Prudential = Real pundit Little Caesar's = Stale articles Nickelodeon = Indolence OK Learjet = Real jet Sikorsky = O! Risk sky Year Two Thousand = A year to shutdown Universal Studios = Visual is nude sort Paramount Pictures = Upon amateur script Banana Republic = Annual bribe cap ================ ================ The Hilton Boeing General Electri MasterCard Lipton te Dreamworks Wire Victoria's Secr Random Hous Virgin Ai Pillsbury Tower Record Lifesavers Whole Foods Princess Cruise Aeroflot Greyhound Siemen Prudential Little Caesar Nickelodeon Learjet Sikorsky = Year Two Thousand Universal Studios Paramount Pictures Banana Republic |
#4
|
|||
|
|||
splitting names can't see whats going wrong (Save My Sanity )
You made your formula a little too long.
Your formula ... revised (shortened) ... produces the correct return: =LEFT(F1,FIND("=",F1)-2) -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "workaholic" wrote in message ... by the way it's XL2000 Corrected typo's I have a long list of words (see below) and in the next column i have this =LEFT(F1,LEN(F1)-FIND("=",F1)-2) The result is in the second list below, as you can see it's not right. No's 3, 5, 7, 8, 9, 10, 15, 18, 20, 22, 23 are in correct. Any ideas what happening here? The Hilton = Hint: Hotel Boeing = Big One General Electric = Electrical Genre MasterCard = Trader scam Lipton tea = Teapot nil Dreamworks = Mad workers Wired = Weird Victoria's Secret = Erotica Victress Random House = Around homes Virgin Air = I arriving Pillsbury = Silly burp Tower Records = Word secretor Lifesavers = Safer lives Whole Foods = Who's fooled? Princess Cruises = Scenic surprises Aeroflot = Fa loot Greyhound = Young herd Siemens = Nemesis Prudential = Real pundit Little Caesar's = Stale articles Nickelodeon = Indolence OK Learjet = Real jet Sikorsky = O! Risk sky Year Two Thousand = A year to shutdown Universal Studios = Visual is nude sort Paramount Pictures = Upon amateur script Banana Republic = Annual bribe cap ================ ================ The Hilton Boeing General Electri MasterCard Lipton te Dreamworks Wire Victoria's Secr Random Hous Virgin Ai Pillsbury Tower Record Lifesavers Whole Foods Princess Cruise Aeroflot Greyhound Siemen Prudential Little Caesar Nickelodeon Learjet Sikorsky = Year Two Thousand Universal Studios Paramount Pictures Banana Republic |
#5
|
|||
|
|||
splitting names can't see whats going wrong (Save My Sanity )
Many Thanks
"RagDyer" wrote in message ... You made your formula a little too long. Your formula ... revised (shortened) ... produces the correct return: =LEFT(F1,FIND("=",F1)-2) -- Regards, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "workaholic" wrote in message ... by the way it's XL2000 Corrected typo's I have a long list of words (see below) and in the next column i have this =LEFT(F1,LEN(F1)-FIND("=",F1)-2) The result is in the second list below, as you can see it's not right. No's 3, 5, 7, 8, 9, 10, 15, 18, 20, 22, 23 are in correct. Any ideas what happening here? The Hilton = Hint: Hotel Boeing = Big One General Electric = Electrical Genre MasterCard = Trader scam Lipton tea = Teapot nil Dreamworks = Mad workers Wired = Weird Victoria's Secret = Erotica Victress Random House = Around homes Virgin Air = I arriving Pillsbury = Silly burp Tower Records = Word secretor Lifesavers = Safer lives Whole Foods = Who's fooled? Princess Cruises = Scenic surprises Aeroflot = Fa loot Greyhound = Young herd Siemens = Nemesis Prudential = Real pundit Little Caesar's = Stale articles Nickelodeon = Indolence OK Learjet = Real jet Sikorsky = O! Risk sky Year Two Thousand = A year to shutdown Universal Studios = Visual is nude sort Paramount Pictures = Upon amateur script Banana Republic = Annual bribe cap ================ ================ The Hilton Boeing General Electri MasterCard Lipton te Dreamworks Wire Victoria's Secr Random Hous Virgin Ai Pillsbury Tower Record Lifesavers Whole Foods Princess Cruise Aeroflot Greyhound Siemen Prudential Little Caesar Nickelodeon Learjet Sikorsky = Year Two Thousand Universal Studios Paramount Pictures Banana Republic |
#6
|
|||
|
|||
splitting names can't see whats going wrong (Save My Sanity )
You're welcome.
-- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "workaholic" wrote in message ... Many Thanks "RagDyer" wrote in message ... You made your formula a little too long. Your formula ... revised (shortened) ... produces the correct return: =LEFT(F1,FIND("=",F1)-2) -- Regards, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "workaholic" wrote in message ... by the way it's XL2000 Corrected typo's I have a long list of words (see below) and in the next column i have this =LEFT(F1,LEN(F1)-FIND("=",F1)-2) The result is in the second list below, as you can see it's not right. No's 3, 5, 7, 8, 9, 10, 15, 18, 20, 22, 23 are in correct. Any ideas what happening here? The Hilton = Hint: Hotel Boeing = Big One General Electric = Electrical Genre MasterCard = Trader scam Lipton tea = Teapot nil Dreamworks = Mad workers Wired = Weird Victoria's Secret = Erotica Victress Random House = Around homes Virgin Air = I arriving Pillsbury = Silly burp Tower Records = Word secretor Lifesavers = Safer lives Whole Foods = Who's fooled? Princess Cruises = Scenic surprises Aeroflot = Fa loot Greyhound = Young herd Siemens = Nemesis Prudential = Real pundit Little Caesar's = Stale articles Nickelodeon = Indolence OK Learjet = Real jet Sikorsky = O! Risk sky Year Two Thousand = A year to shutdown Universal Studios = Visual is nude sort Paramount Pictures = Upon amateur script Banana Republic = Annual bribe cap ================ ================ The Hilton Boeing General Electri MasterCard Lipton te Dreamworks Wire Victoria's Secr Random Hous Virgin Ai Pillsbury Tower Record Lifesavers Whole Foods Princess Cruise Aeroflot Greyhound Siemen Prudential Little Caesar Nickelodeon Learjet Sikorsky = Year Two Thousand Universal Studios Paramount Pictures Banana Republic |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
splitting names can't see whats going wrong (Save My Sanity ) | Excel Worksheet Functions | |||
cannot edit and save | Excel Discussion (Misc queries) | |||
cannot edit and save | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) | |||
Missing "Save" and "Save As" functions | Excel Discussion (Misc queries) |