Spreadsheet help! - Fantasy Baseball Cafe 2014

Moderator: Baseball Moderators

Thanks!

"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

Posts: 9196
Joined: 1 Jul 2003
Home Cafe: Baseball
Location: The Hotel Yorba

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

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

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

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

Wyatt try this:

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

Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

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

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

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

Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

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

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

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

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

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

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

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

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

PreviousNext

### Who is online

Users browsing this forum: joiingds, neuronss and 9 guests

Forums Articles & Tips Sleepers Rankings Leagues

Today's Games
Tuesday, Sep. 16
(All times are EST, weather icons show forecast for game time)

 • Toronto at Baltimore(7:05 pm)
 • Boston at Pittsburgh(7:05 pm)
 • Washington at Atlanta(7:10 pm)
 • Miami at NY Mets(7:10 pm)
 • NY Yankees at Tampa Bay(7:10 pm)
 • Cincinnati at Chi Cubs(8:05 pm)
 • Detroit at Minnesota(8:10 pm)
 • Chi White Sox at Kansas City(8:10 pm)
 • Cleveland at Houston(8:10 pm)
 • Milwaukee at St. Louis(8:15 pm)
 • LA Dodgers at Colorado(8:40 pm)
 • San Francisco at Arizona(9:40 pm)
 • Seattle at LA Angels(10:05 pm)
 • Texas at Oakland(10:05 pm)
 • Philadelphia at San Diego(10:10 pm)