Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

strconv - will it convert letter/number strings

Status
Not open for further replies.

ProgramError

Programmer
Mar 2, 2005
1,027
GB
Does anyone know if strconv will convert a string containing a mixture of numbers and letters
EG "aaxag234ad23"
convert to "AAXAG23AD23"

the strings are serial numbers, therefore can vary in content.
I'll use the ucase and a little programming if it won't work.

Thanks


Program Error
Programmers do it one finger at a time!
 
Did you check out the vbUpperCase constant in the help files?

[tt]EG = "aaxag234ad23"
debug.print strconv(EG, vbUpperCase)[/tt]

Roy-Vidar
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top