Setting formulas to pull data from a specific character spacing...
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"
|