answersLogoWhite

0

The REPLACE function.

User Avatar

Wiki User

7y ago

What else can I help you with?

Related Questions

What are differences between replace and substitute Microsoft Excel functions?

The Replace function replaces part of a text string, based on the number of characters you specify, with a different text string. The Substitute function substitutes newtext for old text in a text string. You use Substitute when you want to replace specific text in a text string and you use Replace when you want to replace any text that occurs in a specific location in a text string.


Write the function replace which finds the string from in the string string and replaces it with the?

Hay buddy this is homework. U have to solve it by urself.


What does the replace command perform in SQL?

The replace command function in SQL preforms comparisons on the collation of an input or inputs. It also replaces the text in a string of the SQL server.


What is the function of pre-defined function LEN in Excel?

The LEN function returns the length of the specified string.=LEN(text)text is the string to return the length for.EXAMPLE:=LEN(word) will return the value of 4.


What is string function visual basic?

A string is a line of text. For example: Dim example As String = "whatever text you want" Would make a string that says "whatever text you want" Later, you can use this for a msgbox or textbox Example: TextBox1.Text = example '(that is the string we made) or MsgBox(example, MsgBoxStyle.Information, "Note!") '(would display a msgbox containing the text in the string)


What is a text string in Excel?

It is simply a piece of text. You can use a piece of text in formulas for doing things. There are specific functions for dealing with text. If you use a piece of text directly in them, as opposed to a cell reference to a cell that has text, the text will be enclosed in quotation marks and can be referred to as a text string. To find a length of a text string you could use the LEN function like this: =LEN("How long is this text string?")


How can I replace strings in a text using a specific method or function?

To replace strings in a text using a specific method or function, you can use the "replace" function in programming languages like Python or JavaScript. This function allows you to specify the string you want to replace and the new string you want to replace it with.


Does the CONCATENATE function in Excel require a text argument?

Normally yes, but it will actually take numbers and combine them into a text string.


A text string contains a string of text?

text data


What text function capitalize the first letter of a string of data?

The capitalize() function in Python can be used to capitalize the first letter of a string. It returns a copy of the string with the first letter capitalized and all other letters in lowercase.


What Replaces existing text by typing over it with new text?

Nothing


Geta is a math function or string function?

GetA is a math function and not a string function.