ExcelBanter - surpress leading and trail spaces

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - surpress leading and trail spaces (https://www.excelbanter.com/excel-programming/403610-surpress-leading-trail-spaces.html)

Souris

surpress leading and trail spaces

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

Your information is great appreciated,

Niek Otten

surpress leading and trail spaces

Look in HELP for the TRIM() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Souris" wrote in message ...
|I just wonder any functions to surpress leading and trailing zeros from the
| string?
|
| Your information is great appreciated,

Souris

surpress leading and trail spaces

Thanks for the message

"Niek Otten" wrote:

Look in HELP for the TRIM() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Souris" wrote in message ...
|I just wonder any functions to surpress leading and trailing zeros from the
| string?
|
| Your information is great appreciated,

All times are GMT +1. The time now is 04:28 PM.