Instead, you better use theCONCATENATEformula to combine that data.
This is where your combined data will be displayed.
If your other columns have headers, give the new column a header name.
Dean Pugh / Unsplash
In our example, it’sFull Name.
you could use this same formula to combine the data from several columns.
Once you’ve completed the formula, pressEnteron your keyboard to activate it.
The new data combination should appear in the cell.
This will apply the formula to all selected rows.
To prevent this, you oughta save all the new entries as a value so they won’t disappear.
