Delete ALL but characters at left or right of cell.

**Trevasaurus** · 01-15-2013, 06:15 PM

Hi.

Is there a formula to delete all characters from a cell except for the first or last two?

Thanks.

**Moo the Dog** · 01-15-2013, 06:22 PM

Well, you could put this in a cell and try it:

=LEFT(A1,2)&RIGHT(A1,2)

That will result in the first two characters of cell A1 immediately followed by the last two characters in A1.

- Moo

**Trevasaurus** · 01-16-2013, 10:33 AM

Awesome.
Thanks Moo

Delete ALL but characters at left or right of cell.

LinkBack

Thread Tools

Rate This Thread

Display

Delete ALL but characters at left or right of cell.

Re: Delete ALL but characters at left or right of cell.

Re: Delete ALL but characters at left or right of cell.

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions