Link to home
Start Free TrialLog in
Avatar of ADRIANA P
ADRIANA PFlag for United States of America

asked on

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

like this ! sample !!
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ADRIANA P


Thanks !! Shums but not coma can be !!
Then change your formula to:

Open in new window

Great ! job !Thnks  Shums
You're Welcome Adriana! Pleased to help :)
UDF copied from here

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

User generated image
Roy_Cox Thanks !! great to learn !! from you !!
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.
Roy_Cox i have just  Excel 2016
I expect the function will be added to 2016 eventually