Formula for Find and replace

Stevekent

Board Regular
Joined
Jul 24, 2013
Messages
97
Office Version
  1. 365
Platform
  1. Windows
Anyone has any formula for Find and Replace. I've a sheet with text or data contains say 7*8/A*B and I'm copied it and need to paste it on a new sheet. I want the data that pasted on the new sheet to automatically change from 7*8/A*B to 7-8/A-B.
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Steve,

can you use a helper column and use SUBSTITUTE to change the "*" to "-".

FarmerScott
 
Upvote 0
Steve,

can you use a helper column and use SUBSTITUTE to change the "*" to "-".

FarmerScott


Actually what I want is say, in simple term, a sheet with data 7*8/A*B in cell A1, and I copied this cell A1 and paste it on another new sheet in A1 as well, but in cell B1, it will automatically show 7-8/A-B. Which means I need a formula in cell B1 to automatically change it instead of using the "Find and Replace" function. My question is what formula to put in cell B1.
 
Upvote 0
not sure if this is what you are trying for. you can paste this in B1
Code:
=SUBSTITUTE(A1,"*","-")
 
Last edited:
Upvote 0

Forum statistics

Threads
1,196,344
Messages
6,014,727
Members
441,841
Latest member
Prabu_sanku

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top