combing multiple cells into one

tinaa140 

I'd be glad to help you combine multiple cells into one in your spreadsheet, but I'll need more information to provide the most accurate solution. Please provide the following details:

Error Message:

• Exactly what error message are you encountering? This will help pinpoint the specific issue.

Data Structure:

• How are the values you want to combine currently arranged across cells? Are they in different rows, columns, or a mix?
• Can you share an example of the current data and the desired output (either in the form of a table or by describing the format you want)?

Software:

• Which spreadsheet software are you using (e.g., Excel, Google Sheets, etc.)? Different software might have different methods for combining cells.

Desired Output:

• How exactly do you want the combined values to appear in the single cell? Should they be separated by delimiters (e.g., commas, spaces), or joined as a continuous string?

Once I have this information, I can offer specific instructions or formulas to help you achieve your goal.

Here are some general approaches you might consider, depending on your requirements:

Concatenation Formulas:

• In Excel, you can use the CONCATENATE function to join text from multiple cells. For example, =CONCATENATE(A1, " ", B1) combines the values in cells A1 and B1 with a space in between.
• Other concatenation functions like CONCAT or TEXTJOIN might be available depending on your software.

Text Join or Merge Functionality:

• Some spreadsheet software has built-in features for joining or merging cells. In Excel, for example, you can use the "Text to Columns" feature followed by appropriate data manipulation.

Copy and Paste:

• If you only need to combine the values temporarily, you can simply copy them from their original cells and paste them into the desired cell, joining them manually using spaces or other separators.

I'm eager to assist you further once I have a clearer understanding of your specific situation!

tinaa140

1. Activate the Formulas tab of the ribbon. Make sure that the Show Formulas button in the Formula Auditing group is not highlighted. 
2. Make sure that the cells containing the formulas are not formatted as Text. If they are, format them as General, then select the top cell, press F2 then enter. Finally, fill down from that cell.