How to Extract?

February 6, 2011 at 11:59:29
Specs: Windows XP
I m user of Excel, required help in VBA
Problem: I have an string " Tel: (+81) -- 0321-4229815(Hassan), 0309-4123454, 0342-4356789 (Amjad)"

above data is sample of one column, I have many rows & columns

I want to extract these numbers in following way

0321-4229815, 0309-4123454, 0342-4356789

Please help me out

See More: How to Extract?

Report •

February 6, 2011 at 13:54:26
I can't tell if you are trying to get all three number strings, separated by a comma, into one cell or get each string into it's own cell.

In either case, start with this:

1 - Select the column
2 - Use Data...Text-To-Columns...Delimited...Next
3 - Check Space, Comma, and enter a ( in the Other box

This should give you this:

   A      B    C        D          E           F            G          H
1 Tel:  +81)  --  0321-4229815  Hassan)  0309-4123454  0342-4356789  Amjad)

If all you want is the values in D, F and G, just delete the other columns.

If you really need 0321-4229815, 0309-4123454, 0342-4356789 in a single cell, use this formula after following the Text-To-Columns steps

=D1 & ", " & F1 & ", " & G1

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

February 6, 2011 at 20:34:51
Thanks for reply,

I also know the use of Text-To-Column but I m searching help in VBA/Macro
because I have huge data and wanna extract numbers only. Sometime I Found data in this shape 0321-4229815;0309-4123454/0342-4356789 0321-4229815
Numbers only to be extracted

it might be better to get result in this way.



Report •

February 8, 2011 at 07:31:51
In your duplicate post (which has been deleted) I believe you had a list of company codes that need to be located.

Please post that list in this thread so that it is available to anyone that might want to help out.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question