Help require to clear unwanted characters from the end

Hi friends,
The code is working fine with correct output but not clearing the extra characters at the end. I want to remove the unwanted characters from the cell.

Please see the following code and suggest me a correction to remove unwanted characters which are at the end.

Please Login or Register  to view this content.

Any help will be appreciated.

Thanking you in anticipation.

What spaces are you referring to, the only spaces I see are from the 21 spaces in the text formula.
The result cell has no spaces at the end.

Hi davesexcel,
See cell 'af8' which has extra spaces and a devanagari word which I want to remove. I have inserted a require output in cell 'ae8' for your reference.

Hope this will help you to achieve the target.

Thank you.

Are you not just able to delete it from the formula you have

Formula:

Please Login or Register  to view this content.

Change it to

Formula:

Please Login or Register  to view this content.

No, The width of column 'B' is large so I have inserted that devanagari word in it which is essential. It means 'clark' for his signature above it. I don't want it in column 'af' onwards in the recording of receipt number, date and time on register sheet. So I want to delete it from there.

Thank you,

See if you can use this,

Please Login or Register  to view this content.

Hi,
No, it's not working. It's deleting the register number in colun 'A' on register sheet which is not correct.

I used the following macro to achieve the target and achieve it with correct output. However it's taking a long time to complete the task. Is there any way to speed up it? I have to run these two macros separately. Is it possible to merge these two macros in a single one? I used the call event but it's not working. If I run it separately then only I get a perfect output.

Please Login or Register  to view this content.

Thank you,