Hi!
I would like to know how can I change the last character (or add or delete a character) in each word, when there are 2 or more words in a cell?
For example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]How is written
[/TD]
[TD]How I would like to be written
[/TD]
[/TR]
[TR]
[TD]whit hors[/TD]
[TD]white horse[/TD]
[/TR]
[TR]
[TD]white agent[/TD]
[TD]whitening agents[/TD]
[/TR]
</tbody>[/TABLE]
I think it would be easier using a formula, but I kinda do not know how to write it correctly.
So I would very much appreciate your help.
Frank
I would like to know how can I change the last character (or add or delete a character) in each word, when there are 2 or more words in a cell?
For example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]How is written
[/TD]
[TD]How I would like to be written
[/TD]
[/TR]
[TR]
[TD]whit hors[/TD]
[TD]white horse[/TD]
[/TR]
[TR]
[TD]white agent[/TD]
[TD]whitening agents[/TD]
[/TR]
</tbody>[/TABLE]
I think it would be easier using a formula, but I kinda do not know how to write it correctly.
So I would very much appreciate your help.
Frank