Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
Can I create a special character for the Character Map? | Excel Discussion (Misc queries) | |||
Custom Character or re-defining a character | Excel Programming | |||
Typing a quote character Vs pasting a quote character= whathappens to the resulting CSV? Interesting!! | Excel Programming |