Re: Deleting first & last character of a field

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Chip Pearson (chip_at_cpearson.com)
Date: 05/22/04 

Date: Sat, 22 May 2004 15:44:57 -0500

Bogga,

In an emty column, use a formula like the following:

=MID(A1,2,LEN(A1)-2)

Copy thig formual down as far as you need to go. Then, copy
these values and do a Paste Special, Values, over the original
data. 

-- 
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Bogga" <anonymous@discussions.microsoft.com> wrote in message
news:2A851209-4D5F-4FB9-B6B0-7EA743590DFE@microsoft.com...
> I have an Excel spread*** that has a field for teacher names.
My problem is that the names show up as |Smith, John|Doe, Mary|
for example.  (The class has 2 teachers).  I can't use the
find/replace because I don't want to get rid of the | that
separates the 2 teachers names.  I just want to get rid of the
ones that are in the beginning of the field and the end of the
field.  Any ideas on how to do that?
Quantcast