Remove spaces without a formula?

Perodin

Board Regular
Joined
Sep 16, 2014
Messages
54
I have a worksheet that is totally generated with formulas and would like to remove and shift up any cell that does not contain a value. I have tried copying and pasting special values, but my data is left with extra spaces that disable my conditional formatting. Is there a way to remove spaces before and after a cell value without using a formula to accomplish it? I have already tried text to columns.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Momentman

Well-known Member
Joined
Jan 11, 2012
Messages
4,040
Office Version
  1. 365
Platform
  1. Windows
As far as I know, you either use a formula or you use a macro. If you use find/replace, it might replace even spaces you intend to keep, except of course all your cells contain only one word in which case the Find and replace would come in handy, but its very unlikely that this is the case
 

Watch MrExcel Video

Forum statistics

Threads
1,109,542
Messages
5,529,454
Members
409,878
Latest member
DDhol
Top