unwanted line space - how do I clear it??

Originally Posted by Ian Parry

I have just inherited a huge document I have to work with where some cells have a line space at the top with text underneath (it's like a para format thing) and some do not. The cells with the space do not behave like I want them to. How do I get rid of the line space? What do I need to do?

Sorry for being dumb but I am no expert. Any help gratefully received.

Hi,

you probably have some cells on the row where the text is using those linespaces, these need the Fornat Cell, 'Wrap Text' option removing.

hth
---

Originally Posted by Ian Parry

Thanks - that worked a treat. I now have another problem. When I save the excel document a s delimited text it sometimes includes inverted commas (speech marks) which I do not want. Can you tell me how to prevent these appearing?

Thank you

don't have commas (or other like data) in your fields, the quotes are to protect 'control' items within your data
(effectively, you can't really get rid of them, the commas and other punctuation are usually there for a reason)

As a last resort I usuall replace all commas in the data with (say) $$#$$ and later replace $$#$$ with comma, but comma is a field separator, so be careful in what you do,

hth
---