Extra Character in cell

D

Daniell

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

tjtjjtjt

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
 

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

Small Thick "Bar" Below Last Typed Line ? 0
matching text to text in excel 3
Problem with MS Word paragraph and character styles: format getting messed up 2
Why am I getting this error? 0
Don't know if it's possible, but... 3
index, match in array setup question 1
Lookup or search using the * character 1
Function or Sub to help with text string 5

Top