Get instant live Excel expert help with CONCATENATE Function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

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
I want the IF function to result in another Function. I am entering the function into cell C31. If cell A31 contains this word (word A), I want it to do the CONCATENATE function to the word in cell B31. If it contains Word B, i want it to do the Subsitute function to the word in cell B31, if it contains Word C, i want it to just return the word in b31 without changing anything.
Solved by D. L. in 18 mins
hi , I'm unable to add to columns one column is date and other is time if I do concatenate the data is changing can you tell me why
Solved by X. U. in 29 mins
In cell C1, use a formula to find If values exist in column A and B of the row, then concatenate the last name first, a comma, a space, and the first initial of the first name into column C of the corresponding row
Solved by B. B. in 22 mins
Only looking at the CME spreadsheet. I used formula on column F to add zeroes which is represented in COlumn G. Now i cant format the data to be currency like how column F is. Additionally I need to concatenate the data to make it more clean and usable. The data i need to concatenate is in Columns E and G. Can you make it look more like how the other spreadsheets look like?
Solved by F. Y. in 29 mins
Hi, I want to concatenate 07.05.2018(Date) & 6:19:08 AM (TIME)
Solved by I. H. in 15 mins
Hi I am trying to calculate days but accounting for blank cells. If both blank do nothing, if both valued subtract. I got that part but trying concatenate with third option,,,, one has date other doesnt so i want to subtract from todays date. I think i am close, any help is appreciated. The aprt before the middle OR works =IF(OR(ISBLANK(O5),ISBLANK(P5)),"",O5-P5 ) OR IF((ISBLANK(O5),P5="*")),Today() - P5,)
Solved by T. C. in 22 mins
Hi I have problem with concatenate two column on excel sheet . Could you please help me for that?
Solved by M. H. in 16 mins
Trying to solve I need to know if something exist in a cell, and if it doesnt then i need it to concatenate some absolute values Example - in cell B5 - it should concatenate K4,M4,O4,Q4
Solved by F. J. in 27 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