Get instant live expert help on how to use concatenate
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need some assistance with a few items on my spreadsheet
Add a column to the right of the "Last Name" column and name as "Full Name." Use the Concatenate function to join First Name and Last Name together split by a space.
Click here for more information on how to use the concatenate function.
Sort Columns C (C2:C21), using A-Z formatting.
Solved by T. S. in 13 mins
concatenate formula useful to compment cloumn
Solved by X. U. in 18 mins
I recently exported a bibliography from word into excel via text. The titles, all between “ and “ have varying lengths therefore diffent columns. Using concatenate how can I make a formula that only concatenates between cells where “ appears, i.e.a concatenate formula of varying columns?
Solved by T. Q. in 28 mins
i need to concatenate some cells with seperators
Solved by X. J. in 19 mins
Could you please explain what is being referenced in the follow string? I am familiar with using INDIRECT and CONCATENATE together.
=INDIRECT(CONCATENATE("'Sheet Name'!",K$1&$A6))
Solved by B. L. in 24 mins