Excel Formula help

[mrbest]

Hi guys,

I've created a tool in excel which reduces the number of characters in a title or line of text.

I want to add a formula so that the the tool can perform a more complex task: I want the tool to also remove any text within brackets plus the brackets.

Does anyone know if this is possible?

thanks in advance

mr best

 

[mrbest]

By 'tool' I mean a thing which makes a person's job easier/less time consuming, the literal meaning of the word.

I'm aware of the search function and I know how to 'find and replace' - This is what i have been doing, but I was hoping in addition to the formula I am using to reduce characters I could also have a formula to do this bit for me - So that I can simply paste text into a field and press enter, displaying the edited text. It's quite a simple concept.

Sorry if I sound like I'm having a go, I'm not, just trying to make myself clearer!

All I need to know is: Is there a formula which can remove any characters within brackets, as well as the brackets from a line of text which has been pasted into a cell.

Miniyazz - I'm not hot on macros, maybe this is something I should look into...

Cheers guys,

mrbest

 

[mrbest]

Is this what you mean?

I'm uploading this solution now and you can examine it to see how it works. I'll explain anything you can't work out.

Edit: Here it is.

Hmmm.... I didn't take into account that there are two spaces, one either side of the brackets, yet the final string seems to only have one space between "this" and "test". If it is a problem though it's easily rectifiable by simply adding 1 to the before brackets part.

Mate! You are a true LEGEND! I knew it was possible. Thankyou so much for your help

mrbest

 

[mrbest]

Sometimes you can get so involved in trying to make something work that it takes someone else to show you something you missed that was right under your nose. That's what I love about these forums - everyone has a piece of knowledge that someone else is looking for

I've got the brackets thing working in my tool now - I'm just trying to adapt it so that it can remove multiple sets of brackets. I've realized that to do this I need to keep inputting the result into another set of the same formulas - the thing I can't work out is how to get the 'Results' field to display the final result (when there are no longer any brackets within the text) because if the result is put through the formulas again after the brackets have all been removed the result of the formulas is just "#VALUE". I think I need a formula to determine when all the brackets have been removed and then display this result. Any suggestions are welcome!

If you need me to upload the example let me know and I will do 2mo!

Thanks again,

mrbest

 

[mrbest]

Hey Antar Bolaeisk,

I've been meaning to get back to you about this but I've been well busy! Thanks again for your great input and for sharing your time to help me. What you posted before was great, the only problem was a lot of the functions aren't supported by the version of excel I'm using. However I was able to fix the multiple bracket problem in a less complex way. I'll post the excel file up here tomorrow so you can see how it worked out. Hmm you say you may have a solution to the space problem? That may still be useful...

cheers,

mrbest

 

[mrbest]

Hey Antar Bolaeisk,

Here's the tool I created. The formulas are hidden to the right of the input fields.

Leezer - I'm not sure with this. Anyone got any ideas?

Cheers,

mrbest