Extra Character in cell
 

I have a very large spreadsheet that two of the colums have 22 characters in
them. The problem is I do not neet the last ten characters. Is there a
function that will read what is in the cell and remove the last ten
characters?

Thanks in advance for the help.

To steal a formula from another Question earlier in the day:
=LEFT(A1,LEN(A1)-10)
should do the trick.
You can thank JulieD and Frank Kabel for this formula.

tj

"Daniell" wrote:

I have a very large spreadsheet that two of the colums have 22 characters in
them. The problem is I do not neet the last ten characters. Is there a
function that will read what is in the cell and remove the last ten
characters?

Thanks in advance for the help.