I am trying to bulk copy data off a excel sheet onto a sharepoint list. I do this by 100 rows at a time, but there are fields that have sevral lines in to cell, which crash my copy in paste into SharePoint.
What I usually do is click on the cell and click backspace so the data comes on to one line, but since there is a a lot of data, this way wont work.
I tried highlighting the cells and click un wrap but it seems that the text is still in separate lines..
Is there a way I can make the text into one line?
Any help or suggestions would be much appreciated.
Thank you
[/URL][/IMG] This is how the data is, but I want it to be in one line like this below....
What I usually do is click on the cell and click backspace so the data comes on to one line, but since there is a a lot of data, this way wont work.
I tried highlighting the cells and click un wrap but it seems that the text is still in separate lines..
Is there a way I can make the text into one line?
Any help or suggestions would be much appreciated.
Thank you