Hi There,
I need change Company Name with XXX, the rule is First word can show full, but start from second word, only first letter show it, the rest are show as "XXX".
For example, ABC Company --> ABC CXXXX; ABC SUSAN COMPANY-->ABC SXXXX CXXXXXXX (The number of "XXX" no need same as the original number of letters.)
The question is, since the length of Company name are very different, and the number of space (" ") are different too, how can I use substitute function to solve it?
Thank you all!
Bookmarks