Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
string function
I have words that are in a cell. How do I count the first x letters of the
sentence? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
string function
Say you want the first six characters of a string in A1:
=LEFT(A1, 6) Put the formula in the cell where you want the six letters to appear. In VBA, you can do: Range("B1") = Left(Range("A1"), 6) for the same effect. "dstiefe" wrote: I have words that are in a cell. How do I count the first x letters of the sentence? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function to evaluate function as string | Excel Worksheet Functions | |||
Looking for String Function | Excel Programming | |||
VBA function : How to search a string in another string? | Excel Programming | |||
String function | Excel Programming | |||
Add Function to String | Excel Worksheet Functions |