Thursday, September 19, 2019

remove or trip trailing spaces and new lines from excel

1. Got fronting or trailing lines in spaces in the cell
- user TRIM function in a new column. For example, To trip trailing spaces from column A, use the following command in new column

2. Remove new line / carriage return from cell contents?

- Use Ctrl+h  (brings up search & replace)
- In the search field, use ctrl+j (opos up return character)
- IN replace field, type the character that you want to replace new line with.
   If you don't want to replace with anything, and just remove the new lines, simply leave it blank
   (don't put spaces, just leave it blank.)