Posts by simplethinks

Re: Extracting the first 6 numbers from a text string (that has other numbers)

Ahhh I'm a bit lost.

I cannot run any of the functions you mentioned as I got an error. Then I tried the VB script and yet nada.
Can anyone help this poor lost soul? As you might have gathered I'm not an expert (not even a power-user of Excel).

Thanks again for all the help.

Re: Extracting the first 6 numbers from a text string (that has other numbers)

NM I see now that I can have a separate column with just the numbers. But it would be extremely handy if I could have the same result automatically to an adjacent column.

Thanks for all the help.

Re: Extracting the first 6 numbers from a text string (that has other numbers)

Thanks cytop.

I only want the first 6 numbers. I want to extract the first 6 numbers of every string in a new column.
e.g.
el_Malcolm_220255_eded41b7ea3932b3f5f089c97d91db5e.arb | 220255
el_Melissa_220310_92d21f1a34be9d21f92ec234b69b99be.arb | 220310

[TABLE="width: 406"]

[tr]

[td]

I have a list of strings like the ones below.

el_Malcolm_220255_eded41b7ea3932b3f5f089c97d91db5e.arb

[/td]

[/tr]

[tr]

[td]

el_Melissa_220310_92d21f1a34be9d21f92ec234b69b99be.arb

[/td]

[/tr]

[tr]

[td]

el_George Benson_276938_Request_1_of_1.html

[/td]

[/tr]

[tr]

[td]

el_Africa_276959_Request_1_of_1.html

[/td]

[/tr]

[tr]

[td]

el_European Parliament Lists_276948_Request_1_of_1.html

[/td]

[/tr]

[tr]

[td]

el_Aeroplane_276944_Request_1_of_1.html

[/td]

[/tr]

[tr]

[td]

el_Movies_293264_ANSWER_en_20130911-58123.xml

[/td]

[/tr]

[tr]

[td]

el_Feldman_220430_(2).txt

[/td]

[/tr]

[/TABLE]

I have tried several formulas but most of them extract the 6 numbers but fail to do so if the string has other numbers after the ones extracted. (see strings marked in red) Can anyone help?

Thanks,
Simplethinks