Hello,

Sorry if this topic has been covered before. I have searched the forum and Google extensively and the only answers I could find that seemed relevant I couldn't understand!

I need to remove numbers from a string of text and put them into new cells in Excel Starter 2010. There are two different values which need moving. The first is in parentheses and the second follows the parentheses.

Here's a few examples of what I mean:

Original text

RED008 - Wickaman and Hoodlum bandwidth (0.06Gb @ 2.00) 0.12
MFR005EP - Various Artists bandwidth (0.19Gb @ 2.00) 0.38
RAZORS010 Future Cut bandwidth (0.01Gb @ 2.00) 0.01

would like to split into...

Cell 1

RED008 - Wickaman and Hoodlum bandwidth
MFR005EP - Various Artists bandwidth
RAZORS010 Future Cut bandwidth

Cell 2

(0.06Gb @ 2.00)
(0.19Gb @ 2.00)
(0.01Gb @ 2.00)

Cell 3

0.12
0.38
0.01

If anyone can help it would literally save me hours of wasted time and soul-destroying boredom. Thanks in advance!