How to create a cell for phone number and callback number

Question

I have a callback number that looks like ex *123445660 to call out to a country. The star needs to be included to for the callback to work. So for example I copy a number in our software and then I get the string " 1 mobile +4570541198" I would like to do a cell that just pass the nine last numbers and then add the callback number too it, so it would look like *1234566070541198. I know you can write =right,9 to fetch the last 9, but how do I do next to get the callback number added?

Tried to create a single cell that will add the callback number to the =right function. To see if it is possible to do it in one cell

Answer 1

for array you will need:

=INDEX("*1234566"&RIGHT(A1:A; 9))