How do you use the replace function in excel?



How do you use the replace function in excel?..

Answer / Satish Kumar Yadav

The REPLACE function in Excel replaces a specific number of characters within a text string. The syntax is: `=REPLACE(text, old_text, new_text, [num_chars])`

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

What is the advantage of using excel for data analysis?

1 Answers  


There are many monetary signs in excel97 but I have not found one yet for the new euro currency. Any suggestions?

1 Answers  


What is the shortcut for pivot table in excel?

1 Answers  


What is the definition of a column in a spreadsheet?

1 Answers  


Why is excel not calculating automatically?

1 Answers  


How do I increase font size in excel drop down list?

1 Answers  


How do I calculate percentage of a total?

1 Answers  


How does len work in excel?

1 Answers  


What is autosum in excel?

1 Answers  


How do I use goal seek in excel?

1 Answers  


What is text formula in ms excel?

1 Answers  


How do you sum a condition in excel?

1 Answers  


Categories