Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUBSTITUTING TEXT FROM A LIST
I have a list of cells containing text to be removed from a collection. What
sort a formula would help to achieve an array matter like: =SUBSTITUTE(A1,B1:B15,"") with items in B1:B15 to be removed from text in A1? Please help urgently. Thanx! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Substituting values | Excel Discussion (Misc queries) | |||
Substituting for cell | Excel Discussion (Misc queries) | |||
Substituting letters for numers | New Users to Excel | |||
Replacing or Substituting Text | Excel Worksheet Functions | |||
substituting two text occurances in same cell. | Excel Worksheet Functions |