[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 280
  • Last Modified:

Need to combine 4 cells into 1 in XL 2003

I'm putting together my Fantasy Football sheet for our league, and I have it in the attached XL 2003 file, but as you can see I have FName, LName, Team and Bye week in 4 separate cells. I would like to combine them all in one cell with a space between each name.

Thanks,
FFB-Test.xls
0
contrain
Asked:
contrain
  • 2
  • 2
1 Solution
 
NorieCommented:
Put this formula in E2.

=A2&" "&B2&" "&C2&" "&D2

It should copy down automatically since you are working with a table.

If it doesn't just drag it down.
0
 
contrainAuthor Commented:
Since I already have data in A2 (the last name) this gives me a circular reference error message.
0
 
NorieCommented:
Just a typo it should have been E2, and I've edited the post.:)
0
 
contrainAuthor Commented:
Worked perfect.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now