[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1319
  • Last Modified:

Increment Letters

Hey,
Is there anyway to increment letters apposed to numbers. So instead of 1,2,3 I would have one,two,three
0
andyb7901
Asked:
andyb7901
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
you may need a table to do that..
not actually incrementing number words, but translating the incremented number..

where do you want to do this?
0
 
Jeroen RosinkCommented:
You might take a look at the funciton mentioned here:
http://xl.barasch.com/cCo11432.htm

Jeroen
0
 
Rey Obrero (Capricorn1)Commented:
see this link
How to Convert Currency or Numbers into English Words
http://support.microsoft.com/?kbid=210586

0
 
ColemssCommented:
Try this:

Dim iCount as integer, strChar as string

for iCount=1 to 26
strChar=str(asc("@" + iCount)
print strChar
next

Or this:

Dim iCount as integer, strChar as string

strChar="A"
for iCount = 1 to 25
strChar=str(asc(strChar) +1)
print strChar
next
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now