string function

  • Thread starter Thread starter dstiefe
  • Start date Start date
D

dstiefe

I have words that are in a cell. How do I count the first x letters of the
sentence?
 
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.
 

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

PowerPoint Powerpoint Slow Animations 2
Unwanted spaces 4
Macro for detect palindromes and repeats in letters/numbers string 1
counting the first letters or first 2 letters in strings 1
Macro for detect and list palindromes and repeats in letters/numbersstring 3
VBA set thick borders around non empty cells in range 0
Sentence Capitalizatio 7
Search a range of cells for a specific word 4

Back
Top