# 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