Changing one phone format to another

[Kreller]

Hi there,

First I would like to thank everybody in the forum! I have gotte
answers to a lot of questions!

Now to the new one. I am making a list of companies. In this list ther
are - of course - telephone numbers for each company. To be able t
search the list and to keep datadiscipline, I want the input to b
standardised with no spacing. Then I can easily search and I can decid
how to represent the data - e.g. in the format "## ## ## ##".

However, when I'm finding the data from external internet resources th
format varies - eg. 1234 5678 or 12 34 56 78. When I copy/paste thi
into the spreadsheet the input is of course as the source which mean
that my cellformatting is "overruled". I'm looking for a way to "force
the input of various forms of representing 8 digits into the forma
"12345678". Hope it is relatively clear what I want... :

 

[Jim Rech]

Excel generally pastes what's in the clipboard and it doesn't have an option
to convert the clipboard contents to the format you have in mind in
mid-paste. So I think you'll have to write a macro to fix the results after
the paste. Shouldn't be too hard.

--
Jim Rech
Excel MVP
|
| Hi there,
|
| First I would like to thank everybody in the forum! I have gotten
| answers to a lot of questions!
|
| Now to the new one. I am making a list of companies. In this list there
| are - of course - telephone numbers for each company. To be able to
| search the list and to keep datadiscipline, I want the input to be
| standardised with no spacing. Then I can easily search and I can decide
| how to represent the data - e.g. in the format "## ## ## ##".
|
| However, when I'm finding the data from external internet resources the
| format varies - eg. 1234 5678 or 12 34 56 78. When I copy/paste this
| into the spreadsheet the input is of course as the source which means
| that my cellformatting is "overruled". I'm looking for a way to "force"
| the input of various forms of representing 8 digits into the format
| "12345678". Hope it is relatively clear what I want...
|
|
| --
| Kreller
| ------------------------------------------------------------------------
| Kreller's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=11635
| View this thread: http://www.excelforum.com/showthread.php?threadid=264126
|