Excel Replace Function Remove Text String

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 can use the REPLACE function. It can remove the text string by position in a 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)

For Example:

If you want to remove text string from a string in Cell B1, and the length of the string that you want to remove is 6, and the starting position number is 1, the new text character can use empty string. Now we can write down the REPLACE function to remove text string:

=REPLACE(B1,1,6,"")

Excel Replace Function Remove Text String1


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 Get Text before or after Dash Character in Excel
get text before dash8

This post will guide you how to get text before or after dash character in a given cell in Excel. How do I extract text string before or after dash character in Excel. Get Text before Dash Character with Formula ...

How to Insert Dashes in Phone Numbers in Excel
inset dash phone number15

This post will guide you how to insert or add dashes in phone number with a formula in Excel. How do I add dashes to telephone numbers in a selected range in Excel. How to separate numbers with dashes in ...

Excel NPER Function
excel nper examples1

This post will guide you how to use Excel NPER function with syntax and examples in Microsoft excel. Description The Excel NPER function returns the number of periods for an investment or loan based on periodic payment amount and a ...

Excel MIRR Function
excel mirr examples1

This post will guide you how to use Excel MIRR function with syntax and examples in Microsoft excel. Description The Excel MIRR function returns the modified internal rate of return for a series of cash flows and the cash flows ...

Excel ISPMT Function
excel ispmt examples1

This post will guide you how to use Excel ISPMT function with syntax and examples in Microsoft excel. Description The Excel ISPMT function used to calculate the interest paid during a specific period of an investment. The ISPMT function is ...

Excel IRR Function
Excel IRR examples1

This post will guide you how to use Excel IRR function with syntax and examples in Microsoft excel. Description The Excel IRR function returns the internal rate of return for a series of cash flows and the cash flows must ...

Fill Blank Cells with specific value (0 or null)
fill empty blank cell with value2

This post will teach you how to fill all blank cells with specific value, such as: 0 or any other values in excel. How to locate all blank cells and then fill in all the blanks with any specific value. ...

Delete Rows Based on Cell Value
remove rows based on values3

This post will guide you how to use the Find & Replace feature to delete or remove all rows based on certain cell value in Microsoft Excel. Or how to delete all rows that contain certain value with VBA code ...

How to Copy Formula without Changing Cell References
copy formula without changing reference7

This post will guide you how to copy formula without changing its cell references to make an exact copy in excel. How to copy and paste formulas or links without changing Cell References. How to copy exact formula from one ...

How to Check If the First Letter is capitalized
check if first letter capitalized4

This post explains that how to check if the first letter in a cell is capitalized or not in excel. How to write an excel Macro to check if the first letter in a specified cell is capitalized or not. ...

Sidebar