RIGHT function should be used to extract the last four digits from a column containing phone numbers.
The Excel TEXT functions section includes the RIGHT Function[1]. A predetermined number of characters from the end of a provided text string will be returned by the function.
The RIGHT function can be helpful in the financial analysis if we want to extract characters from a text string's right side. It is typically used in conjunction with functions like VALUE, SUM, COUNT, DATE, DAY, etc.
Formula is=RIGHT(text,[num chars])
The following arguments are used by the RIGHT function:
Text is the original text string (mandatory argument).
The number of characters to be returned from the end of the provided text is specified by the optional argument Num chars. It specifies how many characters will be taken, beginning on the right side of the text. If the argument is omitted, the value of 1 by default is used.
For more information on excel functions kindly visit to
https://brainly.com/question/22264444
#SPJ4