Formulas on Microsoft XL

  • Thread starter VAIDEESWARAN VENKATESWARAN
  • Start date
V

Thread Starter

VAIDEESWARAN VENKATESWARAN

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
 
Hi Venkatesh!

Can you be more specific on this? If possible e-mail me your sample report so that I can understand it fully and to help you better.


Regards,

Ting

mail to : [email protected]
 
Top