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 to find all values in Sheet 2: Column B that match the values in Sheet 1: Column C-X and return the values in Sheet 1: Column A to Sheet 2: Column E. There may be multiple matches and these need to be Comma Separated (or in separate columns and I can concatenate them afterwards) If some sample data is required please let me know.
Solved by T. W. in 15 mins
hi i want to do the following if value is true on one work book file then one another workbook i want to concatenate all the information in the cells on the row before the true value to be copied over if employer says yes i want the employer information to go to another spreadsheet workbook which is interested employers
Solved by Z. D. in 30 mins
I need to incorporate data validation into the following formula: =IF(C2="Credit Contract Agreement Unsigned",INDEX($D$2:$D$934,MATCH(CONCATENATE(B2,"Credit Contract Agreement Signed"),$E$2:$E$934,0)),"") Column F has a date 14 days after the loaded date, and I need to ensure that whatever result date for a signed is pulled falls within those two dates.
Solved by K. L. in 28 mins
I need help with a google sheets concatenate formula from columsn c, d and e whilst retrieving more information from another sheet
Solved by C. D. in 30 mins
Hello and good morning, i entered a simple concatenate formula to fill down about a thousand rows.. and when i did so.. it only copied the end results of the first cell.. ??
Solved by A. D. in 27 mins
I need to calculate the time and number of days until issues have been resolved. There is a formula for days but also need one for time. I found a formula found in cell N2, but it would require concatenate cells and would make report to complex for my audience.
Solved by I. A. in 14 mins
I need to understand the formula =IF(ISBLANK($G27),"",HLOOKUP(TRIM($G27),INDIRECT(CONCATENATE(H$4,"!$B$11:$HH$31")),21,FALSE))
Solved by M. B. in 14 mins
Hey! I'm trying to copy info from one sheet to another. I use the "T" and Concatenate formulas. Most of the time it works but sometimes on the new sheet it comes out blank. But when I click on the cell it shows the formula.
Solved by M. Y. in 30 mins
I am trying to concatenate 8 rows of data down 3398 columns. All I get is the formula in the cell.
Solved by K. L. in 12 mins
Cheers! How will I show a blank cell even though it has a formula (concatenate)? What I want to happen is, it will only show up after the value takes place on a cell? Please assist. Thanks!
Solved by G. F. in 19 mins