Searching for Alt-Enter in a worksheet

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.
 
P

Pete_UK

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
 

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

Vertical spacing when using <Alt><Enter> 1
Concatenate spaces before each alt-enter seperated value in a cell? 2
How to insert ALT+ENTER (new line) with Replace 7
Find and Replace alt enter 3
Copy & Paste cell that has alt + enter 2
Search for "Alt-Enter" character 3
Replace manual line breaks (Alt+Enter) with two spaces for selectedcells 5
"alt + enter" closes the worksheet 9

Top