Thread: Asc character
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trish[_3_] Trish[_3_] is offline
external usenet poster
 
Posts: 2
Default Asc character

I have a string Ispace, I need to find what the position
is of the first and the second spaces within the string
are. Can someone help with the syntax. I have gotten the
if not question wrong and would appreciate any support:
Trish

Ispace = Trim(Right(ActiveCell, 10))

intI = 1
loop1:
If Not (Asc(Right(Ispace, intI), 32)) Then
intI = intI + 1
GoTo loop1
Else
Space = intI