Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Extracting numbers of a string

5 views
Skip to first unread message

Apaxe2000

unread,
May 10, 2006, 11:37:06 AM5/10/06
to
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

Peo Sjoblom

unread,
May 10, 2006, 11:53:30 AM5/10/06
to
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" <apaxe200...@gmail.com> wrote in message
news:1147275426.4...@j73g2000cwa.googlegroups.com...

SteveG

unread,
May 10, 2006, 11:51:42 AM5/10/06
to

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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7571
View this thread: http://www.excelforum.com/showthread.php?threadid=540713

Apaxe2000

unread,
May 12, 2006, 8:20:48 AM5/12/06
to
Hello.

Thanks for helpme.

Apaxe2000

SteveG

unread,
May 12, 2006, 11:15:27 AM5/12/06
to

You're welcome.
0 new messages