Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 29th 04, 03:49 PM
Don
 
Posts: n/a
Default Words > Numbers (i.e. Vanity Phone Numbers) function

Can anyone point me to an excel function that would
automate the process seen at http://www.phonespell.org/?

The intent is to convert a word (first 10 characters) into
the appropriate numbers.

Thanks,
Don

  #2   Report Post  
Old December 29th 04, 06:10 PM
Frank Kabel
 
Posts: n/a
Default

Hi
you have to create this on your own in VBA. Just processing every single
character of a string. Not really tested but try:

Public Function create_number(sText As String) As String
Dim i As Integer
Dim sReturn As String

For i = 1 To Len(sText)
Select Case UCase(Mid(sText, i, 1))
Case "A", "B", "C"
sReturn = sReturn & "2"
Case "D", "E", "F"
sReturn = sReturn & "3"
Case "g", "H", "I"
sReturn = sReturn & "4"
Case "J", "K", "L"
sReturn = sReturn & "5"
Case "M", "N", "O"
sReturn = sReturn & "6"
Case "P", "Q", "R", "S"
sReturn = sReturn & "7"
Case "T", "U", "V"
sReturn = sReturn & "8"
Case "W", "X", "Y", "Z"
sReturn = sReturn & "9"
End Select
Next
create_number = sReturn
End Function

--
Regards
Frank Kabel
Frankfurt, Germany
"Don" schrieb im Newsbeitrag
...
Can anyone point me to an excel function that would
automate the process seen at http://www.phonespell.org/?

The intent is to convert a word (first 10 characters) into
the appropriate numbers.

Thanks,
Don





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Amount or Numbers in Words ron New Users to Excel 6 December 24th 04 07:32 PM
words and numbers in an IF function Spoony_13 Excel Discussion (Misc queries) 7 December 17th 04 03:29 AM
Phone Numbers natei6 Excel Worksheet Functions 6 November 25th 04 02:38 AM
Is there a way to have a function auto correct words in ALL CAPS . Kelly Seale Excel Worksheet Functions 2 November 18th 04 09:05 PM
how do i convert numbers to words MazenBy Excel Worksheet Functions 2 November 16th 04 05:28 PM


All times are GMT +1. The time now is 10:34 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017