E

Excel help.

I’m feeling dumb today, I know I can and have done this many times. I want to cut characters off the end of text.

It’s easy using the left or right function to keep a certain number of characters, but what I want to keep is what’s changing, I want to cut off a certain # of charaters.

Example:
=LEFT(A1, 13) will keep the left 13 characters so:

‘Control panel (c/o, min, new)’
Would become
‘Control panel’

But: ‘Control (c/o, min, new)’
Would be cut to ‘Control (c/o,’

But I always want to cut off the last 15 characters so I would be left with:
‘control panel’
And ‘Control’

Super dumb as I was trying to type 'Excel help needed' but managed only 'E' in the title before somehow hitting post. Very very dumb today.

You're really off, I think I found a solution on Yahoo Answers

http://answers.yahoo.com/question/index?qid=20071128170757AA9WAqL

Thanks, now mercifuly (I hope!!) this thread can sink down the page order never to be seen again.

F?

Not F. E

=Mc^2

Energy!

Adrian_Thompson wrote: Excel help. I’m feeling dumb today, I know I can and have done this many times. I want to cut characters off the end of text. It’s easy using the left or right function to keep a certain number of characters, but what I want to keep is what’s changing, I want to cut off a certain # of charaters. Example: =LEFT(A1, 13) will keep the left 13 characters so: ‘Control panel (c/o, min, new)’ Would become ‘Control panel’ But: ‘Control (c/o, min, new)’ Would be cut to ‘Control (c/o,’ But I always want to cut off the last 15 characters so I would be left with: ‘control panel’ And ‘Control’

=LEFT(A1, LEN(A1)-15)

Will get you there. The LEN() function returns the length of the contents of the cell.

G (spot). Dunno if this will help with your Excel question, but in other matters... http://en.wikipedia.org/wiki/G-Spot