How to create a cell for phone number and callback number-CodePudding

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

CodePudding user response：

You can concatenate with "&". Please adjust to your desired string for callback:

="*1234566"&RIGHT(A1,9)

CodePudding user response：

use the following syntax:

=(CONCAT(A1,RIGHT(B1,8)))

CodePudding user response：

for array you will need:

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