Trim Text in VBA

[Dracana]

Hello,

I have a small Excel VBA program that pulls data from our company database.
I use this to collect information about orders that have been placed.
The decriptions of our inventory within our accounting software usually go something like this: [2/24] Small Red Rose
The [2/24] stands for 24 pieces per case and 2 pieces per inner pack.
My question is... can I trim off the text '[2/24]' within VBA?
I need to create quotes, labels and other things that use these descriptions and don't need to include the information with the brackets.

Obviously within VBA everything is done with variables, such as strDESC for the description.

Thank you for any help you can provide.

[DonkeyOte]

If this info appears at the top of the string (if at all) then perhaps:

Please Login or Register  to view this content.

[JBeaucaire]

You can actually fix the entire column of data all at once, with a line of code something like this:

Please Login or Register  to view this content.

Notice we are replacing everything inside the brackets PLUS the brackets PLUS one space afterward with nothing.

You could, of course, do the replace string by string within the macro proper, but you could do it all at once as shown.

[Dracana]

Thanks,

One question though. What do I do if the brackets are not there to begin with. Not every description has brackets, just most of them. Will the replacement code error and just leave me with an error code?

[JBeaucaire]

I just tested it on a column with no brackets and I got no error message.

[Richard Schollar]

Either sets of code will work just fine whether the brackets are there or not

[shg]

What do I do if the brackets are not there to begin with.

Testing is a good way to find out

[Dracana]

I just tried it in my program and it worked beautifully!
Thank you very much!