If you need to copy the result after done splitting, combining, or changing the letter case,
without the formula to be carried on, you need to use Paste Special > Value
without the formula to be carried on, you need to use Paste Special > Value
Hope it helps! Thanks and your ideas are welcome! ;)