Simple replace function?

derohanes

New Member
Joined
Aug 15, 2010
Messages
7
Is there an easy way to replace a portion of a string without using left/mid/right functions? The best way to explain is by example. Lets I have in a cell, "Tuesday is the best day of the week," and I want to input into another cell, "Tuesday is the worst day of the week." Is there a simpler way of substituting "worst" for "best" with out having to find the positions and clipping and re-assembling? Something like find "best", replace with "worst".
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,062
Office Version
365
Platform
Windows
There is function for that called SUBSTITUTE. It is pretty straightforward, i.e.
Code:
=SUBSTITUTE(A1,"worst","best")
 

Watch MrExcel Video

Forum statistics

Threads
1,095,939
Messages
5,447,410
Members
405,451
Latest member
BalbasNiBarabas

This Week's Hot Topics

Top