Setting formulas to pull data from a specific character spacing...

[trice_nb]

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!

 

[SteveB]

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]

THANKS, STEVE!!! It worked-You're the best....Have a wondeful Day!