I cannot find a way to do this> i hope someone can help.
this is an example, and there are lots of numbers that can apply.
The qualifying criteria is the number must end with "L", and there is a "-" placed between the number and the "L" after the removal of the brackets
Other numbers inside brackets, like (3.7) remain as they are.
The qualifiers each sit in one column, in cells with up to 500 other characters, and there are over 800,000 rows.
(16.45L)
needs to become
16.45-L
Jack went to Woolies and almost fainted when learning of the price of a (2.4L) milk carton.
needs to become
Jack went to Woolies and almost fainted when learning of the price of a 2.4-L milk carton.
-no spaces
-maximum of 2 decimals inside the brackets
-maximum number is 100
I imagine a helper column could assist if the task is not efficient on a large data set.
i could create a long vba code with a line for each number, but i suspect there is something possible, and it would be great if i could shorten the task - for future reference as well.
this is an example, and there are lots of numbers that can apply.
The qualifying criteria is the number must end with "L", and there is a "-" placed between the number and the "L" after the removal of the brackets
Other numbers inside brackets, like (3.7) remain as they are.
The qualifiers each sit in one column, in cells with up to 500 other characters, and there are over 800,000 rows.
(16.45L)
needs to become
16.45-L
Jack went to Woolies and almost fainted when learning of the price of a (2.4L) milk carton.
needs to become
Jack went to Woolies and almost fainted when learning of the price of a 2.4-L milk carton.
-no spaces
-maximum of 2 decimals inside the brackets
-maximum number is 100
I imagine a helper column could assist if the task is not efficient on a large data set.
i could create a long vba code with a line for each number, but i suspect there is something possible, and it would be great if i could shorten the task - for future reference as well.
