Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a large xlsx file with the last column containing text with carraige
returns (CR). When I save this xlsx as a csv file these interim CR are preserved so each record of data isn't continuous on a single line. Example data: f1, f2, f3, "data for field 4" f1, f2, f3, "more data <carraige return for field 4" f1, f2, f3, f4 I discovered this by opening the csv file in word with paragraph markings turned on and I can see these paragraph marks. Is this a 'feature' of Excel? How can I save a CSV without these pesky returns? I am using this csv in an import routine on another program and it fails without manual corrections. Your help is appreciated...kelly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
save as issue | Excel Discussion (Misc queries) | |||
File Save/Save As Issue | Setting up and Configuration of Excel | |||
VLookup column return issue | Excel Discussion (Misc queries) | |||
Save As Authentication Issue From ASP.NET | Excel Discussion (Misc queries) | |||
UserForm Save Issue | Excel Worksheet Functions |