concatenate

Currently I have an Excel file which enters a time stamp depending on if a value is entered in Column A. So it looks like this <tbody> Column A Column B Column C Data<where value="" is="" entered<<="" td=""></where> Blank<blank for="" now=""></blank> A Date Stamp auto fills when something...

Hi all, Using Excel for Office 365 MSI 16.0.11 x64 version 1902. I have a scenario where I think TEXTJOIN would work, but I can't figure out how to concatenate several IF statements together. I have: - Column A (id) with hundreds of row entries, simple numbers 1-..... - Column B (category)...

I'm looking for a formula in cell D1 and down, that will add 1 or 2 "0" in front of the ( digit or number ) that when I "concatenate" them together from cell A1 with B1 see picture or is there another solution ? Thank you

Cells in "SKU" column are the pasted value of cells in "SKU Formula" (concatenate) column. How do I get the "SKU" column (pasted value) to automatically update when a change is made to data in cells shown in SKU formula? <tbody> Collection Prefix Shape Size Supplier Color Code SKU Formula...

Hi All: I have a weekly file that spits out numbers stored as text. It breaks out the hundreds and thousands amounts in different cells. In thousands cell:205 In hundreds cell:87 = 205,087 I currently use a concatenate formula to combine these two numbers and have to...

I'm revisiting my file and wondered if it's possible to tweak and to apply a minimum and maximum date. Basically, this is my data <tbody> PARTNO1 Hyundai Accent 01/01/94 31/12/99 PARTNO1 Hyundai i30 01/01/98 31/12/16 PARTNO1 Hyundai i40 01/01/99 31/12/17 PARTNO2 Hyundai Accent...

Hi, Excel beginner here and I am trying to create a form with checkboxes that when checked create a text output into a single cell. I have been able to create the checkboxes and get the formulas to work so that all of the text outputs combine into a single cell using the concatenate function...

The bold underlined formula below is equating to 9.63 for the selected fields, which should default to the second concatenate, but for some reason it is defaulting to the first concatenate. Any thoughts on why...

Hi All, I have 1 column with a series of numbers that has 6 digits then 2 spaces and then 4 to 5 digits. i am trying to remove both spaces. I am able to remove 1 space with TRIM but I need to remove the 2nd space. My co-worker has a concatenate that has no spaces and can't add spaces to their...

Howdy folks! You've been my rock many times so I'm hoping someone here has a suggestion. Below is a sample of a spreadsheet with two small bits of data. Start Here is where we need to see if the RANGE of numbers covered by the Bates label columns are found in *ANY* of the values in SHEET 1...

Please see the imagine. https://imgur.com/a/haW7m1x I have a table of information. you can seen cell C15 shows certification number is 2. What formula should I use in cell C16 so it shows 123, 321, 111. concatenate unique values only, based on criteria without macros? How is it done...

Hello and thank you in advance if you can help, I am trying to create a column in a query that compiles/concatenates information from other columns when certain criteria are met. The problem I am encountering is how to put it in terms of Concatenate IIf, or if that is even valid syntax within...

Hi There, I'm trying to concatenate 2 columns ("A") and ("B") into 1 column ("A") with an ";" separator via VBA. I have already have a code that doing stuff already and I want to add the concatenate function in to it, can somebody help? all have to comeback into column A...

I am trying to pull data from individual employee sheets in a workbook. I am trying to concatenate the sheets and match them to the employee name and input the data from the same 4 cells on their worksheet into a table on another worksheet. If I use the IF function I will have to do that formula...

Hi all, first time post so I hope I'm following the correct procedure :) Was really hoping someone could give me guidance. Basically I have a file as per the information below and I need to merge Column2 and Column3 - but based on the value in Column 1. <tbody> PARTNO1 Hyundai Accent...

Hello. I am trying to concatenate two cells that contain time of the day and show them as a time slot in text format (like: 09:30-11:00). I have changed the destination formats to text and also used the TEXT formula but it returns strange numbers (fraction of 24 hrs I assume). How can I change...

Hi, I have columns with values a b c d etc, and i have to bring them all to one cell with a comma(,) after each of the values in the cell. Please help on this. Regards, Nik

Hi, i am ccocatenating 2 columns that are I and J, and i want the test in column I to be bold. how can i do it?

Hello, I am pulling together a string of data including a date with Concatenate and Index/Match. What is being returned is the serial date. How do I format it to a presentable date? It is the index match highlighted in red. Thanks =CONCATENATE("WO ",INDEX(WL[WORK ORDER...

I have a table with a column named "Description" and another column "Tags". I have a named range "tag_data" that lists all the tags I want to search for in the description, and then concatenate the tags into the Tag Column: I am using a function I named ConcatenateArrary based on a...