View original (French)

Word wrap in excel

jfqld Posted messages 8725 Registration date   Status Member Last intervention   -  
Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   -
Bonjour,
I have a small problem:
I have an Excel file with a column (over 850 rows) containing names and first names.
I would like to separate the last names from the first names (one column for LAST NAME and one for FIRST NAME)
but since the last names and first names do not all have the same length, I can't manage to split them.

Example:
DAVID Martin
DOMI DE ALAVRO Pierre
are in one column

I would like (if possible)
Column A Column B
DAVID Martin
DOMI DE ALARO Pierre

Thanks to everyone who can help me

Configuration: Windows XP / Internet Explorer 8.0

--
I will drink milk when the cows eat grapes.

3 answers

  1.
    jfqld Posted messages 8725 Registration date   Status Member Last intervention   127
     
    Thank you very much to MICHEL M

    for Raymond: You can see that it’s not possible !
    thank you for making me look like a fool.

    --
    I will drink milk when cows eat grapes.
    1
    1. Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   17 485
       
      Sure! So when you succeed, will you show us the result?
      0
  2. michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello,

    check out this excellent site
    http://boisgontierjacques.free.fr/
    section "string"
    subsection "matrix formulas...etc"

    provided that at the outset, the last names are in uppercase and the first names in "proper case" format

    Good luck anyway because...
    Michel
    0
  3. Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   17 485
     
    You can see that it's not possible!
    How can the software cope with
    DURAND Jean Alain
    DE COURTEMANCHE DE LA CLÉMANDIÈRE Pierre-Joseph Etienne
    GRANVIER Marie wife of DEMANGE
    LAURENTIDE Annie widow of POULOT
    ?

    It's up to you to prepare the list by placing a special character where Excel should cut the text.
    --
    Retirement is great! Especially in the Antilles ... :-)
    ☻ Raymond ♂
    -1