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" |
Setting formulas to pull data from a specific character spacing...
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" |
Setting formulas to pull data from a specific character spacin
THANKS, STEVE!!! It worked-You're the best....Have a wondeful Day!
-- pnb "God Is Love" "SteveB" wrote: 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" |
All times are GMT +1. The time now is 08:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com