splitting names can't see whats going wrong (Save My Sanity )
 

I have a long list on words (below) 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

splitting names can't see whats going wrong (Save My Sanity )
 

On Mon, 7 Nov 2005 23:17:12 -0000, "workaholic" wrote:

I have a long list on words (below) 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?


Try:

=TRIM(LEFT(F1,FIND("=",F1)-1))

--ron