Asc character

  • Thread starter Thread starter Trish
  • Start date Start date
T

Trish

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
 
iloc = Instr(1,ActiveCell," ",vbTextCompare)
iloc1 = Instr(iloc+1,ActiveCell," ",vbTextCompare)

would be a basic approach.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Read A Text File 2
space in word 1
Saving an e-mail that attaches a workbook 2
Efficiency of Chr() (or &=)? 7
Removing the last empty line (Return) in a text file (CSV format) 6
String to Date 7
Technique used to rotate text labels when creating a PDF file fromAccess 1
Extract files from BLOB corrupts PDF 11

Back
Top