1. K

    Help with matching by alpha and by number

    Hello, Excel friends. I am trying to wrap my head around how to match by alpha and by number. I have below an example of what I'm going for. Example: Meeting group discussions with one group leader for every room number. People assigned to room one with the last name between a-ch will have...
  2. J

    Reorganize Existing Datum With Text Formula

    I have been given many existing data coded as follows "EXMPL1A 05/25/2018 2,150.00 D" (without quote marks) each datum is this format: a descriptor, space, date in mm/dd/yyyy, space, Amount numeric with 2 places to the right of the decimal, space, alpha-character. I need to convert the example...

Some videos you may like

This Week's Hot Topics