Remove characters in a string.

**jncswe** · 09-02-2010, 03:44 AM

Hi,

I want to remove the nine (any number) right or left characters in a string:

Xxlakslfjoasg123456789
should become
Xxlakslfjoasg

or

123456789Xxlakslfjoasg
should become
Xxlakslfjoasg

i.e. like an inverted "right() or left() function".

Appreciate the help

Jesper

**DonkeyOte** · 09-02-2010, 03:49 AM

So you're saying remove the 9 numerics ?

=IF(ISNUMBER(--LEFT(A1&0));REPLACE(A1;1;9;"");LEFT(A1;LEN(A1)-9))

where A1 holds string

(you may need to Translate functions per your installation)

**jncswe** · 09-10-2010, 07:26 AM

Thanks for the help!

Thread: Remove characters in a string.

Thread Tools

Display

Remove characters in a string.

Re: Remove characters in a string.

Re: Remove characters in a string.

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions