This happens when text is pasted into an excel cell from another source like
Word or a soft return has been entered. A soft return in excel is entered by
holding the Alt key while pressing enter. What happens is a CHAR(10)
character is entered allowing the text to be entered on an additional line
within the cell instead of advancing to the next cell. This is a common
problem with importing excel files saved as csv or txt into many database
apps.
Rather than going through the entire file and finding them all I use this
script to copy the file from one sheet to another minus the CHAR(10)
characters.
=SUBSTITUTE('Y:\PathToSheet\[NameOfSheet.xls]Sheet1'!A1,CHAR(10),"")
Doug Pershing
VP-Data & Production
WMSG Inc
1278 Titan Dr
Dallas, TX 75247
(214) 640-2224
e-mail [EMAIL PROTECTED]
web http://wmsginc.com
click on information and news to see the latest at WMSG Inc.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, November 05, 2007 11:20 PM
To: FusionPro Users Forum
Subject: [fusionpro] manual line break in excel cells
I got a excel file from my customer, and have noticed that there are
manual line break with in some of the cells. This creates a problem in
fusion pro when i composed the data. Can anyone help me how to remove the
manual line break.
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
FusionPro 5.0 Now Available!
Variable text on a curve and soft drop-shadows for variable text
LIMITED TIME upgrade offer of $299 per license for current customers:
http://fusionpro.printable.com/store/upgrade
New licenses available for $599 each at:
http://fusionpro.printable.com/store/
All FusionPro 5.0 customers to receive FusionPro 5.1 with
Adobe Acrobat 8 and InDesign CS3 support when released for FREE.
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
--
Users of FusionPro Desktop have unlimited free email support. Contact
Printable Support at [EMAIL PROTECTED]
--
View FusionPro Knowledge Base, FusionPro Samples at
www.printable.com/vdp/desktop.htm
--
To unsubscribe send a blank email to
[EMAIL PROTECTED]
--
--
--
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
FusionPro 5.0 Now Available!
Variable text on a curve and soft drop-shadows for variable text
LIMITED TIME upgrade offer of $299 per license for current customers:
http://fusionpro.printable.com/store/upgrade
New licenses available for $599 each at:
http://fusionpro.printable.com/store/
All FusionPro 5.0 customers to receive FusionPro 5.1 with
Adobe Acrobat 8 and InDesign CS3 support when released for FREE.
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
--
Users of FusionPro Desktop have unlimited free email support. Contact Printable
Support at [EMAIL PROTECTED]
--
View FusionPro Knowledge Base, FusionPro Samples at
www.printable.com/vdp/desktop.htm
--
You are currently subscribed to fusionpro as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
--
--
Note: All e-mail sent to or from this address will be received or otherwise
recorded by the e-mail recipients of this forum. It is subject to archival,
monitoring or review by, and/or disclosure to someone other than the recipient.
Our privacy policy is posted on www.printplanet.com
--
