Delete | after importing to Excel

K

Ken

line break(Ctrl+Return) in access data in the record is chnged to | after
import to excel. How I can get rid of | from imported excel table?

Access source data
I hope this work
A) It should work this way

After import to Excel
I hope this work | A) It should work this way
 
O

oldchippy

Ken said:
line break(Ctrl+Return) in access data in the record is chnged to |
after
import to excel. How I can get rid of | from imported excel table?

Access source data
I hope this work
A) It should work this way

After import to Excel
I hope this work | A) It should work this way
Click to expand...
Hi Ken,

Try Edit > Find > Replace

oldchippy :)
 
Top