Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...
MS Office Forum / Excel / New Users / March 2007

Tip: Looking for answers? Try searching our database.

TRIM()

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
donh - 12 Mar 2007 12:57 GMT
Hi Hope you can help!

Following on from a recent post I want to identify if a space has been
used in cell.  I tried using Trim() but found it leaves the space I
want to remove.

Any help appreciated as always.

Regards

DonH
Reply to this Message
Roger Govier - 12 Mar 2007 13:00 GMT
Hi

Try
=SUBSTITUTE(A1," ","")

Signature

Regards

Roger Govier

> Hi Hope you can help!
>
[quoted text clipped - 7 lines]
>
> DonH
Reply to this Message
donh - 12 Mar 2007 13:38 GMT
Many thanks Roger.

Don
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.