hi i want to remove some words from my data and get result in next cell for ex :
![]()
Cell A | Cell B ============================================================ this is beautiful good fine a | this is a ----------------------------------------------------------- beautiful a fine new this |a this ------------------------------------------------------------ this number beautiful best cool | this number cool -------------------------------------------------------------
any formula to remove these word and get result like in cell b in above.
Bookmarks