Hi
Fozeye,
Yes, "
concatenation" is a word and it refers to the process of combining text from multiple cells into a single cell.
To allow text editing after concatenation, you can use the following steps:
- Select the cell that contains the concatenated text.
- Press F2 or double-click on the cell to enter edit mode.
- Place the cursor at the end of the text you want to edit.
- Press the space bar to add a space after the text.
- Press the backspace key to delete the added space.
- Press Enter to save the changes.
By adding and deleting a space, you are essentially converting the cell from a formula to a value. This will allow you to edit the text without changing the original formula.
Alternatively, you can use the "
Text to Columns" feature to split the concatenated text into separate cells. Here's how:
- Select the cell that contains the concatenated text.
- Go to the "Data" tab in the ribbon.
- Click on "Text to Columns".
- In the "Convert Text to Columns Wizard", select "Delimited" and click "Next".
- Select the delimiter that was used to concatenate the text (e.g. space, comma, semicolon) and click "Next".
- Choose the format for each column (e.g. General, Text, Date) and click "Finish".
This will split the concatenated text into separate cells, which you can then edit individually.
Formula:
// No macro or Visual Basic code found in the text