I have a column of data in a cell and I need to put a : at the end of each item

Blue

Pink

Green

Silver

 

 

1. Select the entire column.

 

2. Press CTRL+H to bring up the Replace dialog box.

 

3. Click into the "Find what" field and type CTRL+J (it will not look like anything happened, but you put a Line Feed character into the cell by doing that).

 

4. Click into the "Replace with" field and type a semi-colon followed by CTRL+J (the field will look like it only has a semi-colon in it, but actually it has a semi-colon followed by a Line Feed character in it).

 

5. Click the "Replace All" button.

 

6. Check the column of data to make sure the semi-colons were inserted.

WE LOVE JOOMLA

Joomwalker is not affiliated with or endorsed by the Joomla Project or Open Source Matters.
The Joomla name and logo are used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.