Replace whole cell with formula if it contains particular string
gladiator
I want to Replace whole cell with a formula if it contains particular string (searchText) , but find and replace is not just replacing searchText with formula and not removing other contents of cell.
Can anyone help.
ttaaoossuu
Use asterisk to mask other cell contents. So you have to search and replace the following line: *searchText*.
In VBA that would look like this:
Cells.Replace What:="*searchText*", Replacement:="=1+1"
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Cannot call executable from extendscript .jsx file
- Next: Iterate through pairs of rows with a condition on MySQL
Related
Related Related
- 1
If a cell contains a certain character replace the whole cell in r
- 2
Replace the whole string if it contains specific letters/character
- 3
Write rows to a CSV file if a cell contains a particular string value
- 4
Convert the cell to the formula with replace
- 5
Replace string with a particular format
- 6
Replace the particular part of string?
- 7
replace a particular word in string
- 8
Excel - Replace cell link in formula with value in cell
- 9
How to replace a matching string if n+2 line contains a particular string
- 10
How to delete rows from excel files if a cell in a particular column contains the string of array?
- 11
Contains a string in a cell
- 12
Checking if a string contains a particular word
- 13
Check if a String contains particular characters
- 14
If particular cell is NOT BLANK copy down FORMULA from above cell
- 15
Using one cell's value in a formula to look up a particular cell
- 16
Using "If cell contains #N/A" as a formula condition.
- 17
How to determine if a cell formula contains Constants?
- 18
Run formula only If cell contains a value
- 19
How to determine if a cell formula contains Constants?
- 20
How to refer within a formula to a cell that contains a wildcard?
- 21
Reference a cell as a string within a formula
- 22
Formula to ignore or treat as empty a cell that contains another formula with no result?
- 23
Excel - Overflow the text of a cell to an adjacent cell that contains a formula
- 24
Differentiate between an empty cell and a cell which contains a formula
- 25
Python regex replace whole string
- 26
Pandas replace not replacing the whole string
- 27
Excel - replace a formula cell with its result automatically
- 28
Excel - Replace offset formula with actual cell reference
- 29
Excel VBA Replace cell with answer from formula
Comments