Remove leading and trailing spaces keeping multiple spaces between words intact

[MikeJ100]

How can I remove leading and trailing spaces keeping multiple spaces between words intact? I notice the TRIM function removes multiple spaces between words .

 

[MikeJ100]

Hi all, I have followed Peter's instructions and this time it works. I must have missed something out.

Thanks all for your help and patience. It has saved me hours of work .

 

[Peter_SSs]

The error values in column E suggest that you don't yet have all available functions. I did preface that formula suggestion with

If you have all the latest functions ..

EDIT:
Ah, I see the following has been resolved.
The error values in column C seem to indicate that you have not followed the numbered steps listed in post #6 carefully. I suggest that you go back through those steps again.

If you may post the actual formulae you have posted to identify where the challenge could be..

Hasn't that already been done?

 

[SanjayGMusafir]

Hi all, I have followed Peter's instructions and this time it works. I must have missed something out.

Thanks all for your help and patience. It has saved me hours of work .

Glad to help you