Get instant live Excel expert help with CONCATENATE Function

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.

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.

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

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

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?

Hi, I want to concatenate 07.05.2018(Date) & 6:19:08 AM (TIME)

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,)

Hi I have problem with concatenate two column on excel sheet . Could you please help me for that?

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

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))