Prev: Hidding rows when sorting
Next: IF Statement or VLOOKUP
From: Emece on 2 Jun 2010 14:10 Thanks to all for your helpful replies. I need a little extra help. I noticed that there are some cases in which I have two names also. So I have the following options: two names and one surname, one name and two surnames, and two names and two surnames. Examples: John Steven Jackson John Jackson John Jackson Ville Which formulas are suitable for all options? I want to obtain names in one cell, surnames in other cell. Thanks again. Regards, Emece.- "Gord Dibben" wrote: > Your method works only with fixed width Micky. > > Which is OK if all first names are same length. > > > Gord Dibben MS Excel MVP > > On Tue, 1 Jun 2010 11:58:01 -0700, ????? (????) ????? > <micky-a[atsymbol]tapuz[dot]co[dot]il> wrote: > > >You may try also the Text to Columns feature. > >In step 2 of 3 drag out(!) the marked vertical divider and press "Finish". > >http://img69.imageshack.us/img69/4248/nonamef.png > >Micky > > > > > >"Emece" wrote: > > > >> Hi. > >> > >> I have a column where I have names and surnames. I want to put name in one > >> column and surname in anoter column. In order to do this, I use Text to > >> Columns, but I have the following issue: if the cell contains for example > >> Juan Pérez, it works ok, but when the cell contains Juan De los Santos, it > >> assumes there are three surnames, and then put me one word in each column. > >> > >> This is the result, with the example mentioned: > >> A B C D > >> Juan Pérez > >> Juan De los Santos > >> > >> How can I indicate that I want De los Santos, all in one cell? > >> > >> Thanks in advance > >> > >> Regards, > >> Emece.- > >> > > . > |