Function to trim first 10 characters off a string

**theletterh** · 07-12-2012, 11:30 AM

Hello all,

Is there a function that does the opposite of LEFT, where the specified string is reproduced without the first 10 characters?

Example:

1234567890apples

becomes

apples

Thanks!

**WallyBackman** · 07-12-2012, 11:32 AM

Try this:

=right(cell address,LEN(cell address)-10)

**MarvinP** · 07-12-2012, 11:37 AM

=Right(Len(A1)-10)
Or
=Mid(A1,11,100) 100 is just a big number...

**daddylonglegs** · 07-12-2012, 11:38 AM

You can use REPLACE function to replace the first 10 characters with nothing

=REPLACE(A1,1,10,"")

**K m** · 07-12-2012, 11:38 AM

Try either of these

=right(A1,6)

If the ending text is of unknown length, try this
=MID(A1,11,LEN(a1)-10)

Kirk

**theletterh** · 07-12-2012, 11:43 AM

I used WallyBackman's formula. Thanks everyone!

Function to trim first 10 characters off a string

LinkBack

Thread Tools

Rate This Thread

Display

Function to trim first 10 characters off a string

Re: Function to trim first 10 characters off a string

Re: Function to trim first 10 characters off a string

Re: Function to trim first 10 characters off a string

Re: Function to trim first 10 characters off a string

Re: Function to trim first 10 characters off a string

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions