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.
|