Extra space in cells from a Sharepoint export

M

manatee2000

New Member
Joined
Apr 29, 2011
Messages
4
Hello All,

I am trying to figure out why there are extra <cr> in cells in a worksheet connected to a Sharepoiint list. The lines do not show in the sharepioint list or in dataview, and a cut and paste as plain text does not solve the issue. I appreciate any guidance.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

P
  • Question
Using VBA to open workbook from Sharepoint opens blank or is inaccessible from within sub
Replies
0
Views
756
phanzom
P
zookeepertx
  • Solved
Pasting data - automatically does a text-to-columns. WHY?
Replies
5
Views
349
Joe4
Joe4
C
  • Question
Porting an Excel application to Access
Replies
6
Views
238
chazrab
C
C
  • Question
Getting the cell address of a sheet cell from the Change Event of a Listbox1's code n = Listbox1.Listindex
Replies
5
Views
285
Legacy 143009
L
A
  • Question
writable cells limited by dropdown
Replies
1
Views
364
CharlesChuckieCharles
C

Forum statistics

Threads
1,214,804
Messages
6,121,652
Members
449,045
Latest member
Marcus05

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top