Hi, FYI, I have an Excel spreadsheet that contains the linefeed (ALT-Enter) character inside of a couple of cells. However, I wish to export this character into a CSV or TAB-delimited file. Whenever I use the Excel SaveAs command to export either format, the results "appear to be" hard return (carriage return) instead of soft return (linefeed). Can anyone tell me whether a VBA macro exists to override this issue?
Some background information... I am performing a Data Merge using Adobe InDesign with a comma-delimited (CSV) file. The problem I am having is with records that contain multiple lines within the same field. After reviewing the completed merged InDesign document, I noticed the results are inaccurate for the remainder of that record. When it gets to the next record some fields are populated incorrectly and what appear to be from the previous record. Thanks in advance for your reply. -Greg -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
