stripping out the first space
 

Hello:

I have a column of date fields. For whatever reason, there is a space in
front of each date in each cell in this column.

I need to strip out this space, so that I can format this column properly.
How do I do this?

If I cannot find a formula, then I will have to go through all 800 cells and
manually take the space out of each cell.

Thanks!

childofthe1980s

stripping out the first space
 

Insert a column to the right of the problem column
use this formula:
=RIGHT(A1,LEN(A1)-1)
Drag down the length of the column
Copy the column
Paste Special... Values Only over the problem column

HTH

Die_Another_Day
childothe1980s wrote:
Hello:

I have a column of date fields. For whatever reason, there is a space in
front of each date in each cell in this column.

I need to strip out this space, so that I can format this column properly.
How do I do this?

If I cannot find a formula, then I will have to go through all 800 cells and
manually take the space out of each cell.

Thanks!

childofthe1980s

stripping out the first space
 

or maybe

Trim ()

http://www.techonthenet.com/excel/formulas/trim.ph

--
mpeplo
-----------------------------------------------------------------------
mpeplow's Profile: http://www.excelforum.com/member.php...fo&userid=3481
View this thread: http://www.excelforum.com/showthread.php?threadid=56535

stripping out the first space
 

Maybe just selecting that range
edit|replace
what: (space bar)
with: (leave blank)
replace all

would work ok

childothe1980s wrote:

Hello:

I have a column of date fields. For whatever reason, there is a space in
front of each date in each cell in this column.

I need to strip out this space, so that I can format this column properly.
How do I do this?

If I cannot find a formula, then I will have to go through all 800 cells and
manually take the space out of each cell.

Thanks!

childofthe1980s

--

Dave Peterson