How to remove space after a particular character

Hi everyone,

I am in need of a help. I have a notepad with some values. In this notepad I would like to remove spaces (if any) after this character ~

For Example if the line in the notepad reads as

Hello*1234*Good Morning~ Thank you

Then I would like to change it to

Hello*1234*Good Morning~Thank you

Please note the space between ~ and Thank you. I want only that space to be removed. and this occurs many times in the notepad each time only the space next to ~ has to be removed.

Is this possible. Please help. Thanks in advance

Actually I need this to be done in Macro.
I tried replaceall method via vba. But that didn't do the trick.

Thank you. it worked. That's all I wanted.

I marked the thread as solved. Thank you

Hi.

sorry to open the same thread again.

A sudden change in the requirement. I need to delete anything that follows ~ character.

Taking same example again

Hello*1234*Good Morning~%Thank you should be changed to Hello*1234*Good Morning~Thank you

another example

Hello*1234*Good Morning~$Thank you should be changed to Hello*1234*Good Morning~Thank you

Thanks in advance

Try

Please Login or Register  to view this content.

Hi Jindon. Thank you for the help. I used your code and I am getting Type mismatch error when the For loop starts. Any idea? Thanks again

Try this then.
If still error, need to see your data.

Please Login or Register  to view this content.

Thankyou. I guess you will need my code. My requirement is below

1. pick a target textpad file where characters after ~ has to be removed ( done coding and working)
2. Remove the characters after ~ (got stuck here)

My code for you

Please Login or Register  to view this content.

I appreciate your help

Is this what you wanted to do?

Please Login or Register  to view this content.

Thank you tigertiger. Your code is working fine.

Thanks much Jindon.

as for now I am keeping this thread in open as I am doing few more changes. Once I am done, I will mark the thread as solved

Hi,

I need one more favor. your latest code is working fine but for one thing which i anticipated.

For example consider the notepad has two lines like this -

Hello*1234*Good Morning~$
Thank you

Then it perfectly removes the $ after the ~

Now lets consider the same case without any character after ~ like this -

Hello*1234*Good Morning~
Thank you

then the output after the execution of code looks like this

Hello*1234*Good Morning~Thank you

I mean the second line merges with the first line if there are no characters after ~. I would like this not to happen. If there are no character after ~ it shouldn't merge the two lines to one. It should leave as it is.

Can you please help. I know this is too much of me to ask and I wasn't clear on the requirements before. My sincere apologizes.