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
>