Searching for Alt-Enter in a worksheet

  • Thread starter Thread starter AC
  • Start date Start date
A

AC

Hi,

I have a .csv file im trying to convert to .wk4, but one of the problems I'm
having is one of the fields is a address field where the user before used
"alt-enter" to create multi line address in one cell.

Is there any way I can search and replace all the "alt-enter" characters and
replace them with commas.
 
Highlight that column, CTRL-H, then:

Find What: CTRL-J
Replace With: , (<comma><space>)
Click Replace All

You might need to turn off Wrap Text, by going to Format | Cells |
Alignment tab.

Hope this helps.

Pete
 
Back
Top