Record a macro from when you paste the info into C2, then while still
selected apply the text to columns
looks something like this which was what I got

Range("C2").Select
ActiveSheet.Paste
Selection.TextToColumns Destination:=Range("C2"), DataType:=xlDelimited,
_
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=True,
_
Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo
_
:=Array(Array(1, 1), Array(2, 1)), TrailingMinusNumbers:=True


you record macros under tools>macro>record new macro, set up a shortcut
maybe and put it into personal macro workbook, then you can start learning
about macros and edit the recorded macros so it will paste it in any cell
that you choose etc.. You can even end up with a macro that opens another
file, copy the necessary info and paste it, uses text to columns to parse
it..


--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"kbkst via OfficeKB.com" <u18755@uwe> wrote in message
news:5c05ebf7b2b2a@uwe...
> Peo Sjoblom:
> Thank you so much, this worked great, however, how do I run a macro on
> this?
> I need to run it completely down my spreadsheet in columns C & D. Sorry,
> but
> I am sort of a novice to excel.
> Thank you,
> kbkst
>
> Peo Sjoblom wrote:
>>You can paste the lot into C2, make sure column D is empty, do data>text
>>to
>>columns, select delimited, next and select space as delimiter, click
>>finish,
>>that should put (216) in C2 and 444-3333 in D2
>>You can record a macro if you do this often and after you have pasted in
>>the
>>same column just run the macro
>>
>>>I previously submitted a question regarding copying and pasting a phone
>>> number. I found that we no longer need to have a 1 in front of the
>>> phone
>>[quoted text clipped - 10 lines]
>>>
>>> kbkst
>
> --
> Message posted via http://www.officekb.com