Thread: Parse string
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default Parse string

dim i as integer
dim str as string
dim car as string
for i = 1 to len(str)
car = mid(str,i,1)
msgbox car
next i


Cordialement,
--
AP


"loopoo" a écrit dans
le message de ...

Hello!

I am quite new to Excel VBA. Can anyone please help me with this issue:
I want to parse a string character by character just like an array.

Is there a function for that??

Thanks in advance,
Chris


--
loopoo
------------------------------------------------------------------------
loopoo's Profile:

http://www.excelforum.com/member.php...o&userid=28792
View this thread: http://www.excelforum.com/showthread...hreadid=529118