| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting/Array Formula
I have a range of cells (A1:A20) that contains either text string A or text
string B. I would like to write a formula that looks at the entire range and changes text string B to text string A automatically. Can I do that? Thank you in advance for your assisteance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting/Array Formula
A formula won't be able to change those cells, but Edit|replace could work.
SJT wrote: I have a range of cells (A1:A20) that contains either text string A or text string B. I would like to write a formula that looks at the entire range and changes text string B to text string A automatically. Can I do that? Thank you in advance for your assisteance. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting/Array Formula
Thanks.
"Dave Peterson" wrote: A formula won't be able to change those cells, but Edit|replace could work. SJT wrote: I have a range of cells (A1:A20) that contains either text string A or text string B. I would like to write a formula that looks at the entire range and changes text string B to text string A automatically. Can I do that? Thank you in advance for your assisteance. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Sum Formula? | Excel Discussion (Misc queries) | |||
| need a conditional formula to generate numbers divisible by 4 between a given starting no. & end No. | Excel Worksheet Functions | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| Conditional Formatting formula not acceptable? | Excel Discussion (Misc queries) | |||
| Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Linear Mode
