Extracting numbers of a string

A

Apaxe2000

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
 
S

SteveG

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
 
P

Peo Sjoblom

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
 
Top