Dear Sir/Madam

Please kindly find attached file name Text.

We would like to make the cells without any space at
the front of the cells . like A3 , after programme, the results
will be D3.

How to make a small programme or formula?

Thanks
Tom

Attached Files

text.xls (18.0 KB, 12 views)

Try the TRIM() function

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

thanks sir my problems solved