What do the LEN and -find commands do in Excel?
 

Can you tell me what these commands are and when you would use them?

Thanks in advance.

What do the LEN and -find commands do in Excel?
 

hi
len counts the number of characters in a cell inclunding punctuation like
commas, periods etc.

find returns the numeric position of a character within a text in a cell (or
number) from the left.

regards
FSt1

"falcios" wrote:

Can you tell me what these commands are and when you would use them?

Thanks in advance.

I use both of these functions regularly.

=LEN(A1) gives the character count of cell A1. I use this when I am checking for spaces that I don't see. I also use this if I want say the all but the last 2 characters. =Left(A1,LEN(A1)-2)

Find lets you determine the location of a particular character or string within another text. Say you have first and last names together in one cell. You can use =Find(" ",A1) This will give the location of the space between the names so you can seperate first and last names.