software

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
number..Yeah! My question now is: I am copying and pasting from a web site
onto my spreadsheet. When I paste it comes out as (216) 444-3333. My
spreadsheet is set up as area code (C2), my phone number (D2). I would like
to be able to paste into C2 which is area code, and have excel automatically
move the phone number to D2. Is there a formula for this?
Thank you to all that have tried to help previously! Hope you can help again.

kbkst

--
Message posted via OfficeKB.com
www.officekb.com/Uwe/Forums.a...excel/200602/1

You can paste the lot into C2, make sure column D is empty, do datagt;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
--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

quot;kbkst via OfficeKB.comquot; lt;u18755@uwegt; wrote in message
news:5bfe3e12973f8@uwe...
gt;I previously submitted a question regarding copying and pasting a phone
gt; number. I found that we no longer need to have a 1 in front of the phone
gt; number..Yeah! My question now is: I am copying and pasting from a web
gt; site
gt; onto my spreadsheet. When I paste it comes out as (216) 444-3333. My
gt; spreadsheet is set up as area code (C2), my phone number (D2). I would
gt; like
gt; to be able to paste into C2 which is area code, and have excel
gt; automatically
gt; move the phone number to D2. Is there a formula for this?
gt; Thank you to all that have tried to help previously! Hope you can help
gt; again.
gt;
gt; kbkst
gt;
gt; --
gt; Message posted via OfficeKB.com
gt; www.officekb.com/Uwe/Forums.a...excel/200602/1If all you are concerned with is to extract the phone number in D2,
then in D2:

=RIGHT(C2,8)

HTH
Kostis VezeridesPeo 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 amp; D. Sorry, but
I am sort of a novice to excel.
Thank you,
kbkst

Peo Sjoblom wrote:
gt;You can paste the lot into C2, make sure column D is empty, do datagt;text to
gt;columns, select delimited, next and select space as delimiter, click finish,
gt;that should put (216) in C2 and 444-3333 in D2
gt;You can record a macro if you do this often and after you have pasted in the
gt;same column just run the macro
gt;
gt;gt;I previously submitted a question regarding copying and pasting a phone
gt;gt; number. I found that we no longer need to have a 1 in front of the phone
gt;[quoted text clipped - 10 lines]
gt;gt;
gt;gt; kbkst

--
Message posted via www.officekb.com

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(quot;C2quot;).Select
ActiveSheet.Paste
Selection.TextToColumns Destination:=Range(quot;C2quot;), 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:=Trueyou record macros under toolsgt;macrogt;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

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