Solved

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

Question 10

Multiple Choice

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,"-","")

Related Questions

Q3: The From Text,From Access,and From Web buttons

Q4: When creating a Web query,tables in the

Q5: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB5369/.jpg" alt=" The text shown

Q6: When an XML document is edited,changes to

Q7: Using the Convert Text to Columns Wizard

Q8: An XML document can be edited in

Q9: A Web query does not import the

Q11: In the expression,<High>270.65</High>,the <High> and </High> are

Q12: Data imported from an Access table is

Q13: The _ function is used to change