Extracting numbers of a string

Hi.

I have many strings like 10+33+98+3+10 and 3+45+33+21+1, each one in a
diferent field of a sheet.

I want pass the values to individual fields, like A1 (10); B1 (33); C1
(98); D1 (3); E1 (10);

I try with MID, LEFT and RIGHT combinate, but the length of the string
is different in each string. I need something that remove the "+"
between the numbers.

Thanks,
Apaxe2000

Use Text to Columns and the "+" as the delimiter.

Using your sample data in A1 and A2. Select A1 & A2. Go to Data, Text to Columns. Select "Delimited" as your option and click next. Select the checkbox next to Other and type in the + in the space provided and click next and then Finish.


HTH

Steve

Hello.

Thanks for helpme.

Apaxe2000

You're welcome.

Steve

Use data>text to columns, delimited, click next and select other delimiter
and put in the plus sign, then click finish. Make sure the columns to the
right are empty before you do this

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Apaxe2000" <apaxe2000Milhoes@gmail.com> wrote in message
news:1147275426.411668.292300@j73g2000cwa.googlegroups.com...
> Hi.
>
> I have many strings like 10+33+98+3+10 and 3+45+33+21+1, each one in a
> diferent field of a sheet.
>
> I want pass the values to individual fields, like A1 (10); B1 (33); C1
> (98); D1 (3); E1 (10);
>
> I try with MID, LEFT and RIGHT combinate, but the length of the string
> is different in each string. I need something that remove the "+"
> between the numbers.
>
> Thanks,
> Apaxe2000
>