REPLACE

Replaces part of a text string with a different text string. This function can be used to replace both characters and numbers (which are automatically converted to text). The result of the function is always displayed as text. If you intend to perform further calculations with a number which has been replaced by text, you will need to convert it back to a number using the VALUE function.

Any text containing numbers must be enclosed in quotation marks if you do not want it to be interpreted as a number and automatically converted to text.

แƒกแƒ˜แƒœแƒขแƒแƒฅแƒกแƒ˜

REPLACE(แƒขแƒ”แƒฅแƒกแƒขแƒ˜; แƒžแƒแƒ–แƒ˜แƒชแƒ˜แƒ; แƒกแƒ˜แƒ’แƒ แƒซแƒ”; แƒแƒฎแƒแƒšแƒ˜ แƒขแƒ”แƒฅแƒกแƒขแƒ˜)

แƒขแƒ”แƒฅแƒกแƒขแƒ˜ แƒ›แƒ˜แƒฃแƒ—แƒ˜แƒ—แƒ”แƒ‘แƒก แƒขแƒ”แƒฅแƒกแƒขแƒ–แƒ” แƒ แƒแƒ›แƒšแƒ˜แƒก แƒœแƒแƒฌแƒ˜แƒšแƒ˜แƒช แƒฃแƒœแƒ“แƒ แƒฉแƒแƒœแƒแƒชแƒ•แƒšแƒ“แƒ”แƒก.

แƒžแƒแƒ–แƒ˜แƒชแƒ˜แƒ แƒแƒ แƒ˜แƒก แƒขแƒ”แƒฅแƒกแƒขแƒจแƒ˜ แƒžแƒแƒ–แƒ˜แƒชแƒ˜แƒ แƒกแƒแƒ˜แƒ“แƒแƒœแƒแƒช แƒขแƒ”แƒฅแƒกแƒขแƒ˜แƒก แƒฉแƒแƒœแƒแƒชแƒ•แƒšแƒ”แƒ‘แƒ แƒ“แƒแƒ˜แƒฌแƒงแƒ”แƒ‘แƒ.

แƒกแƒ˜แƒ’แƒ แƒซแƒ” แƒแƒ แƒ˜แƒก แƒขแƒ”แƒฅแƒกแƒขแƒจแƒ˜ แƒฉแƒแƒกแƒแƒœแƒแƒชแƒ•แƒšแƒ”แƒ‘แƒ”แƒš แƒกแƒ˜แƒ›แƒ‘แƒแƒšแƒแƒ—แƒ แƒ แƒแƒแƒ“แƒ”แƒœแƒแƒ‘แƒ.

แƒแƒฎแƒแƒšแƒ˜ แƒขแƒ”แƒฅแƒกแƒขแƒ˜ แƒ›แƒ˜แƒฃแƒ—แƒ˜แƒ—แƒ”แƒ‘แƒก แƒขแƒ”แƒฅแƒกแƒขแƒก แƒ แƒแƒ›แƒšแƒ˜แƒ—แƒแƒช แƒฉแƒแƒœแƒแƒชแƒ•แƒšแƒ”แƒ‘แƒฃแƒšแƒ˜ แƒ˜แƒฅแƒœแƒ”แƒ‘แƒ แƒขแƒ”แƒฅแƒกแƒขแƒ˜.

แƒ›แƒแƒ’แƒแƒšแƒ˜แƒ—แƒ˜

=REPLACE("1234567";1;1;"444") returns "444234567". One character at position 1 is replaced by the complete NewText.

แƒ“แƒแƒ™แƒแƒ•แƒจแƒ˜แƒ แƒ”แƒ‘แƒฃแƒšแƒ˜ แƒ—แƒ”แƒ›แƒ”แƒ‘แƒ˜

tip

REPLACE wiki page.


Text Functions

Please support us!