V
Dear list,
i have a specific query on using formulas on Microsoft xl, for an example having an variety of texts in one coulumn, i want to display in an specific way in the other coulumn. let me explain take a case study below
column1 column2
text: aa aa
next- bb bb
like that, my objective is to use a single formula to do that,obiviously i will be using search and replace function in nesting.
it works for single condition, but for multiple
conditions it was giving erreor.
can anybody help me out to implement the formula i want.
with best regards
venkatesh
i have a specific query on using formulas on Microsoft xl, for an example having an variety of texts in one coulumn, i want to display in an specific way in the other coulumn. let me explain take a case study below
column1 column2
text: aa aa
next- bb bb
like that, my objective is to use a single formula to do that,obiviously i will be using search and replace function in nesting.
it works for single condition, but for multiple
conditions it was giving erreor.
can anybody help me out to implement the formula i want.
with best regards
venkatesh