surpress leading and trail spaces

  • Thread starter Thread starter Souris
  • Start date Start date
S

Souris

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

Your information is great appreciated,
 
Look in HELP for the TRIM() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I just wonder any functions to surpress leading and trailing zeros from the
| string?
|
| Your information is great appreciated,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlighting leading or trailing spaces 2
Surpressing a Message 3
Supress Confirmation Prompt 1
ECHO OFF applying to MULTIPLE Macros or MODULES! 1
Macro Button and Closing Excel 8
keep duplicated numbers, eliminate single occurances 1
removing leading and trailing spaces 1
supress leading zero 1

Back
Top