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: 11067
(Past Year: 34)
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: unioreimi and 5 guests

Forums Articles & Tips Sleepers Rankings Leagues


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

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

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