If you have an extra /n at the end of every single line then you can use the following formula in the cell to the right of the first row (assuming you're starting on A2):

=LEFT(A2,LEN(A2)-2)

 That will copy the cell minus the last 2 characters. All you have to do then is drag that new cell down to the bottom of your last row.

Don't forget to copy all of the new cells and then paste special, selecting values.

Hope that makes sense!

Lee

You could also use the SUBSTITUTE function to catch any lingering instances.

TRIM(SUBSTITUTE(A1,"/n"," ")) will replace /n with a space and then remove trailing spaces.

Mitch

thanks for the response. i've tried it but it takes the last character off when there is no /n

Can't you simply do a find and replace?  If there is one too many '/n' you could replace '/n/n' with just '/n'.

You could first of all use Auto Filter, and the choose Custom, and then select ends with /n. This should then filter out any rows that you don't want to change, then you could apply the formula.