Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Cells
We want to use Excel to track printing in our office. I am able to get all
the info needed into a spreadsheet, but I have one 1 remaining glitch when I need to sort the information. The project number column includes the full path so there is no way to sort the log by project, but there is the same number of characters before the project number. Is there a way in Excel to create a macro or a function that our billing person can easily apply to the cells in the column that says " delete the first 14 characters in this cell" or "ignore the first 14 characters when reading this cell"? I am not very familiar with macros, so any advice would be appreciated. Thank you and Happy New Year. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells | Excel Discussion (Misc queries) | |||
Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
Need help formatting cells | Excel Discussion (Misc queries) | |||
Formatting Cells | Excel Worksheet Functions | |||
FORMATTING CELLS | Excel Worksheet Functions |