Whether it is possible to make such content transfer in ecxel?

Question

excel

Hello!
Is it possible to transfer the contents of the cells of a column to another column with the replacement of certain contents in them.
There is this:
Column A Column B
Content XXX 1548
XXX content 1679
Some XXX content 1896
Need this:
Content 1548
1679 content
Some 1896 content

Answer 1

Good afternoon. In my opinion, the formula "=substitute ()" will suit you for this, in it you can write what you want to change and for what value.

Answer 2

Flash Fill or Ctrl + E - in Excel 2016 will handle it.