We help IT Professionals succeed at work.

How can I put values from different columns in a single cell

118 Views
Last Modified: 2017-03-27
like this ! sample !!
many-columns-in-one.xlsx
Comment
Watch Question

Managing Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Thanks !! Shums but not coma can be !!
ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
Then change your formula to:
=CONCATRANGE(A4:J4)

Open in new window

ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great ! job !Thnks  Shums
ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
You're Welcome Adriana! Pleased to help :)
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
UDF copied from here

If you are using Office 365 there is a new Function called TextJoin

TextJoin_2.png
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Roy_Cox Thanks !! great to learn !! from you !!
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
This function is available in Excel 2016 if you are an Office 365 subscriber and have the latest version of Office installed. It's also available with Excel Online, Excel Mobile, Excel for iOS, and Excel for Android phones and tablets. If you have Office 365 and can’t see the TEXTJOIN then it’s likely you’re on the Deferred Channel, which hasn’t got  it yet.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Roy_Cox i have just  Excel 2016
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
I expect the function will be added to 2016 eventually
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
GOOD TO KNOW ! ROY

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions