Remove certain characters from a row?

[Guanjin Peter]

let's say row 2 has data that looks like:

apple (kg), apple (g), orange (kg), orange (g)

it is possible to remove the (kg) and (g) tags so that it'll become
apple, apple, orange, orange

using VB code?

 

[Stormseed]

What is nPro ?

 

[Guanjin Peter]

just a integer, a number.

 

[Stormseed]

just a integer, a number

What circumstances you use nPro ? Is it a pre-defined variable by excel to store a number ? Where is it used and where can I find help on this ?

 

[Guanjin Peter]

it is a pre-defined variable....my apologies.

 

[Stormseed]

oh ok. i thought it was something new that I was not aware of..