Help with moving numbers from string of text to new cells

[Jeryl]

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!

[jraj1106]

Hi.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[alansidman]

Assume your data in column A
in B1 =LEFT(A1,LEN(A1)-21)
In C1 =MID(A1,LEN(A1)-20,16)
In D1 =RIGHT(A1,4)
Now copy down.

[Jeryl]

Assume your data in column A
in B1 =LEFT(A1,LEN(A1)-21)
In C1 =MID(A1,LEN(A1)-20,16)
In D1 =RIGHT(A1,4)
Now copy down.

Absolutely amazing! Thanks so much for your help!

[Marcol]

As a point of interest.

If you don't require the brackets wrapping the second element, try this
In B2 Drag Across then Down

Please Login or Register  to view this content.