Sep 09 2020 08:23 AM
Good morning, all. How can I remove the "(blank)" entry showing up in the Beds column of the pivot table. If there is no data in those cells, I'd like to be empty. Any help would be greatly appreciated.
Sep 09 2020 08:47 AM
Staying on cell with blank in formula bar enter space instead of it. Refresh.
Sep 09 2020 09:16 AM
Sep 09 2020 09:22 AM
@slohombre , you are welcome
Sep 10 2021 08:57 AM
@Sergei Baklan Okay, now how do I undo that? I can't edit the cell and delete the space, and it hasn't modified my source data in any way.
Sep 10 2021 11:27 AM
You can't remove value here, but you may type <blank> instead of space.