Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Zami
 
Posts: n/a
Default Fix the order of the last name and first name

How do I fix the order of the names, when the last name is first and the
first name is second, separated by a comma.
  #2   Report Post  
Biff
 
Posts: n/a
Default

Hi!

What order do you want them in?

Biff

-----Original Message-----
How do I fix the order of the names, when the last name

is first and the
first name is second, separated by a comma.
.

  #3   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
try
=TRIM(MID(A1,FIND(",",A1)+1,255)) & " " & TRIM(LEFT(A1,FIND(",",A1)-1))

--
Regards
Frank Kabel
Frankfurt, Germany

Zami wrote:
How do I fix the order of the names, when the last name is first and
the first name is second, separated by a comma.



  #4   Report Post  
John Mansfield
 
Posts: n/a
Default

Zami,

Another formula option in addtion to Frank's . . .

=MID(TRIM(H38),FIND(" ",TRIM(H38),1)+1,LEN(TRIM(H38)))&"
"&LEFT(TRIM(H38),(FIND(",",TRIM(H38))-1))

turns "Bowman, Frank" into "Frank Bowman".

----
Regards,
John Mansfield
http://www.pdbook.com


"Zami" wrote:

How do I fix the order of the names, when the last name is first and the
first name is second, separated by a comma.

  #5   Report Post  
Zami
 
Posts: n/a
Default

Thank you...

"Biff" wrote:

Hi!

What order do you want them in?

Biff

-----Original Message-----
How do I fix the order of the names, when the last name

is first and the
first name is second, separated by a comma.
.




  #6   Report Post  
Zami
 
Posts: n/a
Default

I want first name then last name

"Biff" wrote:

Hi!

What order do you want them in?

Biff

-----Original Message-----
How do I fix the order of the names, when the last name

is first and the
first name is second, separated by a comma.
.


  #7   Report Post  
Zami
 
Posts: n/a
Default

Thank you I'll try that...

"Frank Kabel" wrote:

Hi
try
=TRIM(MID(A1,FIND(",",A1)+1,255)) & " " & TRIM(LEFT(A1,FIND(",",A1)-1))

--
Regards
Frank Kabel
Frankfurt, Germany

Zami wrote:
How do I fix the order of the names, when the last name is first and
the first name is second, separated by a comma.




  #8   Report Post  
Zami
 
Posts: n/a
Default



"Frank Kabel" wrote:

Hi
try
=TRIM(MID(A1,FIND(",",A1)+1,255)) & " " & TRIM(LEFT(A1,FIND(",",A1)-1))

--
Regards
Frank Kabel
Frankfurt, Germany

Zami wrote:
How do I fix the order of the names, when the last name is first and
the first name is second, separated by a comma.




  #9   Report Post  
Zami
 
Posts: n/a
Default

Thank you, I'll reply to let you know which one was helpful.

"John Mansfield" wrote:

Zami,

Another formula option in addtion to Frank's . . .

=MID(TRIM(H38),FIND(" ",TRIM(H38),1)+1,LEN(TRIM(H38)))&"
"&LEFT(TRIM(H38),(FIND(",",TRIM(H38))-1))

turns "Bowman, Frank" into "Frank Bowman".

----
Regards,
John Mansfield
http://www.pdbook.com


"Zami" wrote:

How do I fix the order of the names, when the last name is first and the
first name is second, separated by a comma.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"