If your data is in field A2, in field A3 enter the formula;
=mid(A2,5,1)

This will give you 1st character from the 5th character in field A2.

SteveB

"trice_nb" wrote:

Hi Chip,

I read your reply to a posting on the discussion board and came to the
conclusion, €œyou are an Excel genius!€� I am trying to identify and insert
data in a €˜new field based on a series from another field: see below

Job No. Department €˜new field
77656S 6
I would like to set a formula where the 5th character in the Job No. column
(in this case 6) will be automatically be placed in the €œDepartment€�. This
way I could set an auto-filter if I am looking for department related data
only.

I hope my request makes sense to you. Your help is greatly appreciated in
advance!

--
pnb
"God Is Love"