Excel Replace function with numeric values

In excel, how to replace a numeric characters within a text string using another numeric characters. This post will guide you how to use REPLACE function to replace numeric characters using another numeric characters in one text string.

The Excel REPLACE function replaces all or part of a text string with another text string

The syntax of the REPLACE function is as below:

=REPLACE(old_text, start_num, num_chars, new_text)

If you want to replace numeric characters that are part of text string with another text string, it can be numeric characters, for example: replacing the numeric characters “2010”of text string “excel 2010” with another number “2016”, you can use the following REPLACE function in excel 2016:

=REPLACE(B2,7,4,2016)

excel replace function with numeric values1

The returned results of REPLACE function is still a text string, you can see that the text string “excel 2016” be returned.

You can also just replace one or more digits within a number, we can use another REPLACE formula to reflect the above request.

=REPLACE(B1,10,1,6)

excel replace function with numeric values1

In the above example, the REPLACE Function will only replace one digit that are part of numeric characters with a new numeric value “6”. The text string “excel 2016” will be returned.


Related Formulas

 Related Functions

  • Excel Replace function
    The Excel DATE function returns the serial number for a date.The syntax of the DATE function is as below:= DATE (year, month, day) …

 

Related Posts
How to apply a formula in entire column or row without/with dragging
apply formula without drag7

This post explains that how to apply an excel formula in entire column or row through dragging fill handler in excel. How do I apply formula in entire column or row without dragging fill handler by shortcut or Fill command. ...

Get the Current Workbook Name
Get the Current Workbook name5

This post explains how to get the current workbook name in excel. Get the Current Workbook Name In excel, the CELL function can get the information of the current worksheet, it will return the full file name and its path. ...

Split Text and Numbers in Excel
Split Text and Numbers in Excel4

This post explains how to split text and numbers in excel, or how to extract the text characters from another strings with text and numbers combined. Split Text and Numbers If you want to split text and numbers, you can ...

Split Text String by Specified Character in Excel
Split Text String by Specified Character2

This post explains how to split text string by a specified character (such as: comma, space, dash, slash, etc.) using FIND function within other functions in excel. And you will learn that how to extract part of characters to the ...

Excel Replace Function Remove Text String
Excel Replace Function Remove Text String1

This post will teach you how to remove a text string of specified length from another text string in a cell. Excel Replace Function Remove Text String If you want to remove text string from a cell in excel, you ...

Combining the REPLACE Function with FIND Function to Remove Text in Excel
Combining the Replace function with Text function 2

How to remove a text string or characters from a cell when the text is at a specific position. And this post will guide you how to remove a text string from a cell or column that the removed text ...

Combining the Replace function with Text function in Excel
Replace function combine with Text function in Excel1

In excel, we can use Replace function in combination with Text function to replace date characters that are part of the text string. And this post will guide you how to use TEXT function as the first arguments to replace ...

Convert Date to Day of Week in Excel (get day name from date )
Get a day name of the week using WEEKDAY and CHOOSE function1

In excel, how to get the day of week from an excel date value. How to return a day name of the week from a date that is contained in a cell in Microsoft Excel. This post will guide you ...

Convert date to month and day only in excel
Convert date to month and day with Text Function 2

In excel, how to get the month and day string from an excel date value. How to convert the dates to text string, just only display as month and day. This post will guide you how to convert date to ...

Convert date to month and year only in excel
Convert date to month and year with Text Function2

In excel, how to get the month and year string from an excel date value. How to convert the dates including both date and time to text string, just only display as year and month. This post will guide you ...

Sidebar