Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
How can I put values from different columns in a single cell
like this ! sample !!
many-columns-in-one.xlsx
many-columns-in-one.xlsx
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi Adriana, you can use below UDF which would be much easier:
Adriana-many-columns-in-one_v1.xlsm
Function CONCATRANGE(varRange As Range, Optional varDelimiter As String)
Dim varTemp As Range
For Each varTemp In varRange
CONCATRANGE = CONCATRANGE & varDelimiter & varTemp
Next
If varDelimiter <> vbNullString Then CONCATRANGE = Mid(CONCATRANGE, 2)
End Function
=CONCATRANGE(A3:J3,",")
Adriana-many-columns-in-one_v1.xlsm
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.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial