EE-5.xlsx

Tom M

1603306437263.png

<div>
Thanks for the points. &nbsp;Glad to help.
</div>


<div>
<div class="content wysiwyg-content fr-view">
What formula will give me the numbers to the left of the -<br>&nbsp;<table><tbody><tr><td>0-Regular</td></tr><tr><td>1-Overtime</td></tr><tr><td>2-Double Time</td></tr><tr><td>501-Vacation</td></tr><tr><td>502-Sick</td></tr><tr><td>503-Holiday</td></tr><tr><td>504-Floater</td></tr><tr><td>505-Funeral</td></tr><tr><td>506-Jury Duty</td></tr></tbody></table><br>
</div>
</div>



What formula will give me the numbers to the left of the -
 
0-Regular
1-Overtime
2-Double Time
501-Vacation
502-Sick
503-Holiday
504-Floater
505-Funeral
506-Jury Duty

numbers on one side of delimiter

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.