Spreadsheet help! - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

Spreadsheet help!

Moderator: Baseball Moderators

Postby LBJackal » Mon Jan 31, 2005 7:23 pm

Thanks!
Image

"Jack, will you call me, if you're able?"

"I've got your phone number written, in the back of my Bible."
LBJackal
Hall of Fame Hero
Hall of Fame Hero

User avatar
Pick 3 Weekly Winner
Posts: 9196
Joined: 1 Jul 2003
Home Cafe: Baseball
Location: The Hotel Yorba

Postby jellyroll » Mon Jan 31, 2005 7:58 pm

here's another one. sometimes spreadsheets from various sources will be in different name formats.

i.e.
Thomas, Frank vs Frank Thomas

so try:
Last, First flip =TRIM(MID(A2,SEARCH(" ",A2)+1,LEN(A2)))&",
"&TRIM(MID(A2,1,SEARCH(" ",A2)-1))
jellyroll
Minor League Mentor
Minor League Mentor

User avatar

Posts: 527
Joined: 6 Jun 2003
Home Cafe: Baseball
Location: West Indies

Postby Wyatt » Fri Feb 04, 2005 10:46 am

I'm trying to use the formula to reverse the name without the comma.

EX Thomas,Frank to Frank Thomas

Do I just click the cell beside the name & than click on the( = sign in the edit formula field), enter the formula

Last, First flip =TRIM(MID(A2,SEARCH(" ",A2)+1,LEN(A2)))&",
"&TRIM(MID(A2,1,SEARCH(" ",A2)-1))

When I do this I get this #NAME?

Any help Thanks
Wyatt
College Coach
College Coach


Posts: 202
(Past Year: 1)
Joined: 28 Jan 2005
Home Cafe: Baseball
Location: Tennessee

Postby Amazinz » Fri Feb 04, 2005 1:55 pm

Wyatt try this:

=RIGHT(A2,LEN(A2)-SEARCH(" ",A2,1))&" "&LEFT(A2,SEARCH(",",A2,1)-1)
Amazinz
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Postby Wyatt » Fri Feb 04, 2005 2:11 pm

My players name is listed like this Bonds,Barry The only way I can get the formular to work is if I put a space & make it look like this Bonds, Barry
Wyatt
College Coach
College Coach


Posts: 202
(Past Year: 1)
Joined: 28 Jan 2005
Home Cafe: Baseball
Location: Tennessee

Postby Amazinz » Fri Feb 04, 2005 2:15 pm

Then just switch that first space with a comma. Like this:

=RIGHT(A2,LEN(A2)-SEARCH(",",A2,1))&" "&LEFT(A2,SEARCH(",",A2,1)-1)
Amazinz
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Postby Wyatt » Fri Feb 04, 2005 2:27 pm

Thanks that done the trick I can use Excel some but not to figure out all these formulas
Wyatt
College Coach
College Coach


Posts: 202
(Past Year: 1)
Joined: 28 Jan 2005
Home Cafe: Baseball
Location: Tennessee

Postby Cooner » Fri Feb 04, 2005 2:44 pm

Wyatt wrote:Cool I just asked my boss this morning how to do this. He only knew how to perform it in access. Alot easier in excel.

Thanks


when you asked your boss, did you tell him it was so that you could do your fantasy projections during work? if so, is he still your boss? !+)
Cooner
Major League Manager
Major League Manager

User avatar

Posts: 1028
Joined: 2 May 2004
Home Cafe: Baseball
Location: my home is in NYC, my heart is in PNC Park

Postby Wyatt » Fri Feb 04, 2005 2:57 pm

Nope but as long as I do my job he really don't care I like to multi task
Wyatt
College Coach
College Coach


Posts: 202
(Past Year: 1)
Joined: 28 Jan 2005
Home Cafe: Baseball
Location: Tennessee

Postby citti34 » Sat Feb 05, 2005 4:16 pm

I'm having a problem when trying to follow the instructions in using the database. The database 'lahman_52' is read only, it states:
You won't be able to save changes made to data or object definitions in this database.
citti34
Minor League Mentor
Minor League Mentor

User avatar

Posts: 608
Joined: 16 Apr 2004
Home Cafe: Baseball

PreviousNext

Return to Baseball Leftovers

Who is online

Users browsing this forum: No registered users and 7 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Saturday, Oct. 25
(All times are EST, weather icons show forecast for game time)

Kansas City at San Francisco
(8:07 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact