extract name formula

  1. H

    Extract (not delete) double entries of two columns combined

    Hello again, I'll try to explain what I want: I have a list of participants of trainings. Column F has the last names Column G has the first names Now I have many trainings and some participants attend more than one training. So, I want to "extract" the first and last names of people to a...
  2. M

    Extracting Names w Formula Many Different Characters

    In the range A2:A5 I have the names: Mike J Hunter Norman-Price Smith Harry. Redknapp Prince-H, Hughes My goal is to extract First, Middle and Last names to get this: Mike -------------- J ----------- Hunter Norman ----------- Price ------- Smith Harry ------------- ------------ Redknapp...

Some videos you may like

This Week's Hot Topics