How do I export/save a shhet where some of the cells have multiple line values

F

fred flintstone

At the office I wrote a perl script to proces the data exported/saved
from an excel spreadsheet. I noticed that the perl script processed
more lines than existed rows in the spreadsheet. Upon closer
examination I noticed that some of the cells have multiple line
values.

Is there any way I can control the action of the export/save so that
the multiple line val;ues are combined into a single line ?



Thanks...
 
G

Gord Dibben

The cells with multiple lines would have linefeeds in them.

This would be the character 0010 which is entered using Alt + Enter

Select all cells before export/save and Edit>Replace

What: CTRL + j

With: space or nothing

Replace all.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move multiple values in single Cell To Cells of there own? 3
Why do Excel cells not calculate until I hit "save" 2
How do I sum cells that have values from a text formula? 4
How do I copy some cells(including formatting) and save as image fileusing VBA? 1
How do I export the results of a table into excel? 3
How to export unlocked cells to a row in a text file. 0
How do I Add Data at the beginning of multiple cells in Excel? 3
How do I protect cells or a range of cells in excel spreadsheet? 1

Top