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

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
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,224,827
Messages
6,181,194
Members
453,021
Latest member
pingpong7117

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