To change a social security number in cell A1 from the 506-32-4462 format to 506324462 in cell B1,you would type ________.
A)=SWAP(A1,"-","")
B)=EXCHANGE(A1,"-","")
C)=SUBSTITUTE(A1,"-","")
D)=REPLACE(A1,"-","")

Name: To change a social security number in cell A1 from the 506-32-4462 format to 506324462 in cell B1,you would type ________. A)=SWAP(A1,"-","") B)=EXCHANGE(A1,"-","") C)=SUBSTITUTE(A1,"-","") D)=REPLACE(A1,"-","")
Brand: Quizplus
Rating: 4.7 (32 reviews)

Question

Quizplus · Accepted Answer

The Answer is C

To Change a Social Security Number in Cell A1 from the 506-32-4462