remove leading space

[daniels012]

Is there a formula I can use to remove a leading space in cell A1??

Thank you

 

[HalfAce]

Try:
=TRIM(A1)

That will remove all excess spaces, as in any leading, trailing and anything over one space between text or numeric values.

That help?

 

[Brian from Maui]

ASAP Utilities

www.asap-ulitities.com

Hey Dan!

 

[HalfAce]

Hey Brian! How is it???
(And yes, I forgot about ASAP.)

Gettin kinda chilly here. Got up to 17 degrees the other day.
On the good side, a golf ball will go better than a half mile on the lake without really smackin' it that hard!

 

[daniels012]

Thank You very much
Half Ace


Michael

 

[HalfAce]

Most welcome. But you really might want to check out the link to ASAP Utilities that Brian provided.
Many many useful things there. You won't be sorry.

 

[daniels012]

I have loaded it on my computer at home. Although it is very difficult to find the things you want quickly.

Michael

 

[Andrew Barbaro]

ASAP Utilities

www.asap-ulitities.com

Hey Dan!

The page cannot be displayed
The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings.

Is this page working for anyone else? TIA.

 

[Brian from Maui]

spelling error....

www.asap-utilities.com