Excel problem - blank line above text in cell

[haz_pro]

Hey everyone,

Been searching for a solution on Google for days but to no avail so hoping some one where can help!

I have imported a medium to large spreadsheet into a sharepoint (2007) list, however there is something about some of the cells which is causing the internet browser to crash when changing to datasheet view.

I believe this error is occuring because in some of the text cells there is a blank line above the text in the cell. I have tried different cell formatting, alignment etc. but the blank line will not go.

Any ideas?

Thanks in advance.

 

[Deception]

Can you get a screenshot?

 

[haz_pro]

Unfortunately the data is work related so can't post a screenshot.

I have just noticed the blank line disappears if I change font from Calibri, to for example Arial.

It seems changing the font doesn't remove the blank line for all the cells with this issue.. :-\

Since I can't post a screen shot hopefully this will help:-


_________
Normal cell


______________________

Problem cell with blank line


Hopefully that makes sense...

 

[Deception]

Can you not copy and paste the data in to a new spreadsheet? Is the link directly above the text or is it a border?

 

[jamesy505]

I dont quite get the problem

 

[Sin_Chase]

Dump out the cell content to a MsgBox with VB and check the contents there also.

Sounds like you have a LineBreak character code in your data?

 

[Participant]

Unfortunately the data is work related so can't post a screenshot.

You can't post a single example cell in conjunction with the MS Paint eraser tool?