Posted to microsoft.public.excel.programming

Souris

external usenet poster

Posts: 107

surpress leading and trail spaces

I just wonder any functions to surpress leading and trailing zeros from the
string?

Your information is great appreciated,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Leading zero's trail Number	C-Breeze	Excel Worksheet Functions	3	April 7th 10 05:26 AM
how do I remove leading spaces and leave the remianing spaces w	Debi	Excel Worksheet Functions	6	February 28th 07 03:29 PM
Trim Leading Spaces	Steven	Excel Worksheet Functions	6	February 21st 07 11:21 PM
How do I add leading spaces to a value?	Chris Brown	Excel Worksheet Functions	3	March 3rd 06 05:23 PM
Remove Leading Spaces	Kirk P.	Excel Discussion (Misc queries)	3	March 3rd 05 01:30 PM

All times are GMT +1. The time now is 08:11 AM.

About Us

"It's about Microsoft Excel"