• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About

REPLACE Function in Excel

The Excel REPLACE function is used to replace existing characters in a cell with a different set of characters, or with nothing. These unwanted characters can appear as a result of importing or copying data into Excel.

The syntax for the REPLACE function is:

=REPLACE(old_text, start_num, num_chars, new_text)

ArgumentPurpose
Old_textThe text that you want to change. Usually entered as a cell reference
Start_numThe start position of the first character in old_text that you want to replace
Num_charsThe number of characters from start_num that you want to replace
New_textThe new data to be added. Leave it blank to just remove the unwanted characters

The examples below show the REPLACE function being used change characters in an existing cell.

REPLACE function in Excel to replace characters in a cell
FunctionResult
=REPLACE(A2,1,5,)1,245.40
=REPLACE(A3,6,4,”Duo”)Hans Duo
=REPLACE(A4,9,4,”crazy”)Computercrazy

Primary Sidebar

Recent Posts

  • Excel SWITCH Function – Nested IF Function Alternative
  • Sum Formulas Only in Excel
  • How to Calculate Age in Excel
  • Custom Sort in Excel
  • Case Sensitive Lookup with XLOOKUP in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

LinkedIn Twitter YouTube

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Blog
  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2009 Computergaga · All Rights Reserved ·