Delete | after importing to Excel
 

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

Delete | after importing to Excel
 

Ken Wrote:
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
Hi Ken,

Try Edit Find Replace

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=570558