Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
character spacing Excel 2003 | New Users to Excel | |||
Character Spacing? | Excel Discussion (Misc queries) | |||
HOW DO I SORT DATA USING A SPECIFIC CHARACTER IN A CELL | Excel Discussion (Misc queries) | |||
Excel pull data based upon one specific word between two date | Excel Worksheet Functions | |||
Excel 2003 -- Character spacing within the same cell | Excel Discussion (Misc queries) |