I have words that are in a cell. How do I count the first x letters of the sentence?
D dstiefe Nov 1, 2008 #1 I have words that are in a cell. How do I count the first x letters of the sentence?
J JLGWhiz Nov 1, 2008 #2 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.
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.
