Use Regex to Format String

[swaggerbox]

I'm using Word 2010. Is it possible to format a certain string using Regex?

See example input below:
2.2 parts of yellow ink, 2.5 parts of black ink and 3 parts of white ink

and preferred output below:
yellow ink (2.2), black ink (2.5) and white ink (3)

any help would be greatly appreciated.

[macropod]

This isn't so much a case of formatting as re-structuring. Try a wildcard Find/Replace where:
Find = (<[0-9.]{1,}>) part[s ]{1,2}of (<*> ink)
Replace = \2 (\1)
No vba required. If you want to have it as a macro, though, simply switch on the macro recorder and record the Find/Replace.

[swaggerbox]

thanks paul. i didn't know this could be done without vba.