Microsoft Excel Help - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to General Talk

Microsoft Excel Help

Moderator: Baseball Moderators

Microsoft Excel Help

Postby pomplona's finest » Sat Nov 06, 2004 1:29 pm

Is there a way to take the info from one column and combine it with another?

I have a list of players with their last names in one column and their first names to the right. I want to put the last names in alphabetical order, but if I did that the first names would not coordinate. any help?
[URL=http://www.imageshack.us]Image[/URL]

AKA IRON CHEF

Member #5 of the Inaugural Yadier Molina Fan Club!!!
pomplona's finest
General Manager
General Manager

User avatar
Eagle Eye
Posts: 3062
Joined: 18 May 2004
Home Cafe: Baseball
Location: Dirt Farming in Madagascar

Postby Tavish » Sat Nov 06, 2004 2:51 pm

If you do a full sort you shouldn't need to combine the first and last name columns. Excel will keep the row data together and sort on the desired column.
Image

Bury me a Royal.
Tavish
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe SpotterWeb Supporter
Posts: 11068
(Past Year: 26)
Joined: 3 May 2004
Home Cafe: Baseball

Postby pomplona's finest » Sat Nov 06, 2004 3:04 pm

Tavish wrote:If you do a full sort you shouldn't need to combine the first and last name columns. Excel will keep the row data together and sort on the desired column.


heh, thanks I didnt realize it was so simple. :*)
[URL=http://www.imageshack.us]Image[/URL]

AKA IRON CHEF

Member #5 of the Inaugural Yadier Molina Fan Club!!!
pomplona's finest
General Manager
General Manager

User avatar
Eagle Eye
Posts: 3062
Joined: 18 May 2004
Home Cafe: Baseball
Location: Dirt Farming in Madagascar

Postby JTWood » Sat Nov 06, 2004 4:33 pm

But to answer the original question, if you have data in column A and column B and you want to merge them together, use this formula in column C:

=A1&B1 - Copy as needed.

Make sure you copy column C and paste special (values) over column C to get rid of the formula before you delete the original data.

;-D
Image
JTWood
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicCafe WriterEagle EyeWeb Supporter
Posts: 11508
Joined: 22 Jun 2004
Home Cafe: Baseball
Location: Unincorporated Heaven


Return to General Talk

Who is online

Users browsing this forum: No registered users and 5 guests

Forums Articles & Tips Sleepers Rankings Leagues


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

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

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