Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
loop through a cell.
I have this:
Function ctTxt(cvTxt As String) ctTxt = Left(UCase(cvTxt), 1) & "" & Right(cvTxt, Len(cvTxt) - 1) End Function Which takes the cell which contains. hello free world and converts it to Hello free world. ... but how can I make the function loop to say Hello Free World. every first letter capitalized. i'm think combining the Len() and Instr() function to create some type of loop, but it seems that I'm stuck. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop Until non-incrementing cell condition met. | Excel Worksheet Functions | |||
Loop through last cell/row of used range | Excel Discussion (Misc queries) | |||
Is it possible to reset the starting cell in a For Loop | Excel Discussion (Misc queries) | |||
Loop using cell names | Excel Programming | |||
get for loop to go on after blank cell? | Excel Programming |