remove empty spaces in data

**kisboros** · 02-11-2013, 07:01 PM

I have a 1500-row database. I'd like to left-justify all the numbers but there are uneven spaces preceeding groups of numbers. What to do?
Thank you!

**martindwilson** · 02-11-2013, 07:09 PM

select column
data text to columns fixed width
click next,
double click any break lines to remove them click next
if you need to preserve leading zeros change field to text if not leave as general
click finish
alternatively use find replace
find a single space replace with nothing

**kisboros** · 02-11-2013, 07:26 PM

Hmmm...I thought of this but the leading spaces are all over the place. No code will help?

OK, tried it it worked. Thank you.

**bstier** · 02-12-2013, 01:24 AM

The trim function is a great function for this.

=Trim(a1)

**FDibbins** · 02-12-2013, 01:33 AM

try =TRIM(A1) copied down

**amitkr3855** · 02-12-2013, 04:15 AM

In C1

=A1+0

**visha_1984** · 02-12-2013, 04:36 AM

try in B1

Please Login or Register  to view this content.

and drag down

**Kevin UK** · 02-12-2013, 07:44 AM

Hi kisboros

Select the data in column A >> Data Tab >> Text to Columns >> Delimited >> Ensure everything is unticked >> Finish. Then Home Tab >> Editing >> Clear >> Clear Formats.

This worked for the file that you uploaded!