Re: 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 = Fare: 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 **** 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

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 = Fare: 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 **** 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
>
>
>

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 = Fare: 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 **** 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
>
>
>

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" <[email protected]> wrote in message
news:%[email protected]...
> 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 = Fare: 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 **** 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
> >
> >
> >
>
>

Many Thanks




"RagDyer" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:%[email protected]...
> > 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 = Fare: 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 **** 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
> > >
> > >
> > >
> >
> >
>

You're welcome.
--

Regards,

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

"workaholic" <[email protected]> wrote in message
news:[email protected]...
Many Thanks




"RagDyer" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:%[email protected]...
> > 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 = Fare: 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 **** 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
> > >
> > >
> > >
> >
> >
>