QUESTION : Anyone have thoughts on why this won’t work? I keep getting #VALUE. =IF(E22:K22<>””, CONCATENATE(E22, ” “, “of”, ” […]
Tag: concatenation
Concatenate four binary files using alternating pattern in Linux
Problem : I need to concatenate four binary, meaning non-text files. Lets say I have four files: file1: AAAA file2: […]
Excel data dump column formatting
QUESTION : I format a data dump from our software and am trying to streamline the process. The first column […]
Conditional Concatenate inserting or not inserting underscores depending on cell value
QUESTION : I’m a beginner on excel and I’m trying to get the following result: Col1 Col2 Col3 Col4 John […]
Flatten/Concatenate an array to a list for match in excel formula
QUESTION : I have a table of data in excel which has double header rows. I would like to perform […]
concatenate files from different subdirectories
Problem : I have many subfolders from my current operating directory. In each subfolder, there is a file called “total” […]
Excel_prefixed with 0 and how to concatenate those columns in excel
QUESTION : https://www.icts.uiowa.edu/confluence/display/REDCapDocs/Preserving+Prefixed+Zeros+in+Excel with the help of the above link i prefixed the 0 in excel. Now i want to […]
trying to concatenate commands to give a file path
Problem : I’m trying to concatenate several commands to give a file path. I need to run this: ls -l […]
concatenate files from different subdirectories
Problem : I have many subfolders from my current operating directory. In each subfolder, there is a file called “total” […]
Concatenating a range of values in Excel
QUESTION : I have a set of values that I would like to concat together using a formula. At the […]