need help deleting space in cell with data

[andrewsolomon]

I have pasted a 1000 dates in the format mm/yyyy

However, when pasted in, the dates all have a space at the end of the
last c
harachter. I want to delete that space so Excel recognizes field as a
date.
The trim function seems to be only for text. Can anyone provide a
solutio
n? Any help would be great.
Thank you in advance.

 

[Ron Coderre]

There are a few approaches for this. Try this one

1)Format the cells as dates
Format>Cells>Category Date (select a date format)
2)Select the list of text-dates
3)Date>Text to Columns>Delimited.....[Next]
Uncheck all delimiters......[Finish]

Does that work for you?

Ron

 

[andrewsolomon]

ron,
thanks so much for the message. What do you mean by
3)Date>Text to Columns>Delimited.....[Next]
Uncheck all delimiters......[Finish]

Do I right click and see "Date". I wasn't sure how exactly to select
Date.

 

[Ron Coderre]

Sorry....Fat fingers...

Date should be DATA (on the Excel main menu).

Regards,
Ron

 

[andrewsolomon]

Sorry Ron. I see you meant DATA. I got it to work. Thanks so much

 

[Peo Sjoblom]

If it has a trailing space then it is text, I assume you tried it? If it
didn't work most likely you have html garbage.


=--TRIM(SUBSTITUTE(A1,CHAR(160),""))



--
Regards,

Peo Sjoblom

(No private emails please)


"andrewsolomon" <[email protected]>
wrote in message
news:[email protected]...