Phantom space

Flanker1900

New Member
Joined
Dec 9, 2022
Messages
1
Office Version
  1. 365
I have a pivot table that is inputting a phantom space in one of the rows. I have a few columns in the file, the last file being a text box that I enter that is actually not a part of the pivot table (just something I manually added). I have input an image of the issue, but I'm not sure why it is inputting a space in the field. This only happens on rows that I have multiple lines of text (so, if I have text in that last manual column that I had put in and it's just on one line without the text wrapping, everything is fine...the problem is that when the text wraps it adds this phantom space). I can't expand the text column, as this needs to be printed out in a format that is easy to read - so some rows need to have the text wrap.
 

Attachments

  • Phantom Space.png
    Phantom Space.png
    4.9 KB · Views: 18

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Is it not the space between the words? The wrap text is applied just before the space so it's the first character on the new line?
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,637
Latest member
Ezio2866

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