Formula to remove a string and parenthesis in excel

[rkulasekaran]

Hello All,

I need to remove a particular string from the cells ina column "bpar()" and paste the other contents in the new column. Kindly do find the sample excel file.
Thanks in advance for your help.

[Pete_UK]

Put this formula in C3:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A3,"bpar",""),"(",""),")","")

then copy down.

Hope this helps.

Pete

[rkulasekaran]

Thanks pete for your reply. It works fine.

[Pete_UK]

Glad to help - thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete

[rkulasekaran]

Hello ,
Still I need to extract few more details, please do find the attached file. Kindly do hep me out.

[Pete_UK]

Put this formula in C3:

=IF(ISNUMBER(FIND("==",A3)),LEFT(A3,FIND("==",A3)-1),A3)

and this one in D3:

=IF(C3=A3,"",MID(SUBSTITUTE(A3,C3,""),6,LEN(SUBSTITUTE(A3,C3,""))-8))

then copy down.

Hope this helps.

Pete

[rkulasekaran]

Thanks, once again for your reply.

[rkulasekaran]

Hello Pete,
I need a macro to extract few values from a column (i.e) Please find the attached. Here in the file whichever is within "par(xxxx)" and "bpar(xxxx)" must be copied and paste the values into the new columns based on occurrences. kindly please do help me out. Thanks in advance for your reply.

[Pete_UK]

You started out asking for a formula, and I gave you one and the thread was marked solved.

Then you came back with a different problem, which I solved for you.

Now you are asking for something different again.

I think you should start a new thread, rather than keep adding new variations to this one (see Forum Rules).

Pete