software

I know there's a way to change names that are first name last name to a list
that is last name, first name. Can someone help me with this?
Cheri

It's not a Excel Formatting thing......and there are several ways to do it,
depending on EXACTLY how the names are arranged. One way is to highlight
the column and do Data gt; TextToColumns gt; and use comma as the
delimiter......this will break the names into two columns and then they can
be CONCATENATED back together in the desired order..........things to watch
out for with any automatic method is middle initials or names, prefixes,
titles, etc.

hth
Vaya con Dios,
Chuck, CABGx3

quot;Cheriquot; wrote:

gt; I know there's a way to change names that are first name last name to a list
gt; that is last name, first name. Can someone help me with this?
gt; Cheri

Assume name in A1 with first amp; last separated by one or more blanks (no
middle name):

in B1:=TRIM(RIGHT(A1,LEN(A1)-FIND(quot; quot;,A1)) ) amp; quot; quot; amp; TRIM(LEFT(A1,FIND(quot; quot;,A1)-1))

quot;CLRquot; wrote:

gt; It's not a Excel Formatting thing......and there are several ways to do it,
gt; depending on EXACTLY how the names are arranged. One way is to highlight
gt; the column and do Data gt; TextToColumns gt; and use comma as the
gt; delimiter......this will break the names into two columns and then they can
gt; be CONCATENATED back together in the desired order..........things to watch
gt; out for with any automatic method is middle initials or names, prefixes,
gt; titles, etc.
gt;
gt; hth
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt;
gt; quot;Cheriquot; wrote:
gt;
gt; gt; I know there's a way to change names that are first name last name to a list
gt; gt; that is last name, first name. Can someone help me with this?
gt; gt; Cheri

Slight mod to eliminate the comma following the last name.........

=TRIM(RIGHT(A1,LEN(A1)-FIND(quot; quot;,A1)) ) amp; quot; quot; amp; TRIM(LEFT(A1,FIND(quot;,quot;,A1)-1))

Vaya con Dios,
Chuck, CABGx3
quot;Toppersquot; wrote:

gt; Assume name in A1 with first amp; last separated by one or more blanks (no
gt; middle name):
gt;
gt; in B1:
gt;
gt;
gt; =TRIM(RIGHT(A1,LEN(A1)-FIND(quot; quot;,A1)) ) amp; quot; quot; amp; TRIM(LEFT(A1,FIND(quot; quot;,A1)-1))
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; It's not a Excel Formatting thing......and there are several ways to do it,
gt; gt; depending on EXACTLY how the names are arranged. One way is to highlight
gt; gt; the column and do Data gt; TextToColumns gt; and use comma as the
gt; gt; delimiter......this will break the names into two columns and then they can
gt; gt; be CONCATENATED back together in the desired order..........things to watch
gt; gt; out for with any automatic method is middle initials or names, prefixes,
gt; gt; titles, etc.
gt; gt;
gt; gt; hth
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Cheriquot; wrote:
gt; gt;
gt; gt; gt; I know there's a way to change names that are first name last name to a list
gt; gt; gt; that is last name, first name. Can someone help me with this?
gt; gt; gt; Cheri

How would I get the comma between Lastname, Firstname?

quot;CLRquot; wrote:

gt; Slight mod to eliminate the comma following the last name.........
gt;
gt; =TRIM(RIGHT(A1,LEN(A1)-FIND(quot; quot;,A1)) ) amp; quot; quot; amp; TRIM(LEFT(A1,FIND(quot;,quot;,A1)-1))
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Toppersquot; wrote:
gt;
gt; gt; Assume name in A1 with first amp; last separated by one or more blanks (no
gt; gt; middle name):
gt; gt;
gt; gt; in B1:
gt; gt;
gt; gt;
gt; gt; =TRIM(RIGHT(A1,LEN(A1)-FIND(quot; quot;,A1)) ) amp; quot; quot; amp; TRIM(LEFT(A1,FIND(quot; quot;,A1)-1))
gt; gt;
gt; gt; quot;CLRquot; wrote:
gt; gt;
gt; gt; gt; It's not a Excel Formatting thing......and there are several ways to do it,
gt; gt; gt; depending on EXACTLY how the names are arranged. One way is to highlight
gt; gt; gt; the column and do Data gt; TextToColumns gt; and use comma as the
gt; gt; gt; delimiter......this will break the names into two columns and then they can
gt; gt; gt; be CONCATENATED back together in the desired order..........things to watch
gt; gt; gt; out for with any automatic method is middle initials or names, prefixes,
gt; gt; gt; titles, etc.
gt; gt; gt;
gt; gt; gt; hth
gt; gt; gt; Vaya con Dios,
gt; gt; gt; Chuck, CABGx3
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Cheriquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I know there's a way to change names that are first name last name to a list
gt; gt; gt; gt; that is last name, first name. Can someone help me with this?
gt; gt; gt; gt; Cheri

=TRIM(RIGHT(A1,LEN(A1)-FIND(quot; quot;,A1)) ) amp; quot;, quot; amp; TRIM(LEFT(A1,FIND(quot;,quot;,A1)-1))

Cheri wrote:
gt;
gt; How would I get the comma between Lastname, Firstname?
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; Slight mod to eliminate the comma following the last name.........
gt; gt;
gt; gt; =TRIM(RIGHT(A1,LEN(A1)-FIND(quot; quot;,A1)) ) amp; quot; quot; amp; TRIM(LEFT(A1,FIND(quot;,quot;,A1)-1))
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Toppersquot; wrote:
gt; gt;
gt; gt; gt; Assume name in A1 with first amp; last separated by one or more blanks (no
gt; gt; gt; middle name):
gt; gt; gt;
gt; gt; gt; in B1:
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; =TRIM(RIGHT(A1,LEN(A1)-FIND(quot; quot;,A1)) ) amp; quot; quot; amp; TRIM(LEFT(A1,FIND(quot; quot;,A1)-1))
gt; gt; gt;
gt; gt; gt; quot;CLRquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; It's not a Excel Formatting thing......and there are several ways to do it,
gt; gt; gt; gt; depending on EXACTLY how the names are arranged. One way is to highlight
gt; gt; gt; gt; the column and do Data gt; TextToColumns gt; and use comma as the
gt; gt; gt; gt; delimiter......this will break the names into two columns and then they can
gt; gt; gt; gt; be CONCATENATED back together in the desired order..........things to watch
gt; gt; gt; gt; out for with any automatic method is middle initials or names, prefixes,
gt; gt; gt; gt; titles, etc.
gt; gt; gt; gt;
gt; gt; gt; gt; hth
gt; gt; gt; gt; Vaya con Dios,
gt; gt; gt; gt; Chuck, CABGx3
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Cheriquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; I know there's a way to change names that are first name last name to a list
gt; gt; gt; gt; gt; that is last name, first name. Can someone help me with this?
gt; gt; gt; gt; gt; Cheri

--

Dave Peterson