Replace nonprinting character

P

pecan

I have an Excel cell with an address in, and each line of the address is
separated by a non-printing character. I need to replace it so that I can
use the 'text to columns' function to get each line of the address into
separate columns.

The find & replace function won't recognise the nonprinting character, and
the clean/trim/substitue formuale seems only to be capable of removing it.
Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom toolbar button for search and replace 1
How to bulk add section breaks after a particular combination of letters/numbers 0
replace 5
Format column widths from one table to a separate table on same page 1
Lookup or search using the * character 1
Prompt For Replace in Selection And More... 0
Excel 2003 imported Outlook contacts have nonprinting characters 1
Remove non-space spaces? 3

Top