erasing empty spaces
 

I have a colum of data that has spaced before the text...the number of spaces
varies per cell..

how do i eliminate the spaces within each cell?

Thank you

erasing empty spaces
 

With Range("A1:A12")
.Offset(, 1).Value = Application.Trim(.Value)
End With

Regards,
Peter T

"dstiefe" wrote in message
...
I have a colum of data that has spaced before the text...the number of
spaces
varies per cell..

how do i eliminate the spaces within each cell?

Thank you

erasing empty spaces
 

If you want to get rid of all the space characters, you could:

Select the range to fix
edit|replace
what: (space character)
with: (leave blank)
replace all

don't do this if the cells contain other spaces that need to be kept.

dstiefe wrote:

I have a colum of data that has spaced before the text...the number of spaces
varies per cell..

how do i eliminate the spaces within each cell?

Thank you

--

Dave Peterson

erasing empty spaces
 

See if =TRIM(A1) and pull down does what you want.

HTH
Regards,
Howard

"dstiefe" wrote in message
...
I have a colum of data that has spaced before the text...the number of
spaces
varies per cell..

how do i eliminate the spaces within each cell?

Thank you

erasing empty spaces
 

use TRIM function. e.g. if your data is in column A, you could put formula
in b1:
=TRIM(A1) and copy down the length of your data. removes both leading and
trailing spaces.

"dstiefe" wrote:

I have a colum of data that has spaced before the text...the number of spaces
varies per cell..

how do i eliminate the spaces within each cell?

Thank you