Replace ~ in a string according to criteria

Hi,
i need to process a word list which looks like:

__________________________
Now is:
__________________________
abondance ~s
abondant, ante
abonder
.....~ dans le sens de qqn.
abonnement
abonner (1)
.....s'~
abonné, ée
abord
.....au premier ~ de prime ~
.....aux ~s
.....d'~
abordable
abordage
____________________________
_____________________________

Now i need tildas "~" of those cells to be replaced, which start with 5 spaces. The ~s have to be replaced by the string of the last cell without ~ and 5 spaces at the start. Only that part of cell has to be pasted in place of ~ which is not between "()".


__________________________
should be:
__________________________
abondance ~s................no change because it doesnt start with 5 spaces
abondant, ante
abonder
.....abonder dans le sens de qqn.
abonnement
abonner (1).........those parts of string which are in () should not be pasted
.....s'abonner
abonné, ée
abord
.....au premier abord de prime abord
.....aux abords
.....d'abord
abordable
abordage
____________________________
_____________________________


I will be thankful for each idea or solution.replace_tilda_with_upper_word.xlsmreplace_tilda_with_upper_word.xlsm

hi, simcode
thank you very much. It doesn't replace all ~s as i tried it on larger list. I am uploading the large list. It will be kind if you could have a look at it.

I think this will do what you want. You should adjust the range where the result is put.

Please Login or Register  to view this content.