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" |
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) |