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
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
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
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
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: 612
(Past Year: 4)
Joined: 16 Apr 2004
Home Cafe: Baseball

PreviousNext