Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 17th 08, 08:04 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 2
Default how do i switch the first and last name in a cell?

I want to switch a person's first and last name in a cell, what should I do?

  #2   Report Post  
Old June 17th 08, 08:39 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,440
Default how do i switch the first and last name in a cell?

Look he

http://www.cpearson.com/excel/FirstLast.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Slac" wrote in message ...
|I want to switch a person's first and last name in a cell, what should I do?


  #3   Report Post  
Old June 17th 08, 08:43 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default how do i switch the first and last name in a cell?

With James Ravenswood in A1
=REPLACE(A1&" "&LEFT(A1,FIND(" ",A1)),1,FIND(" ",A1),"")
displays
Ravenswood James
--
Gary''s Student - gsnu200792


"Slac" wrote:

I want to switch a person's first and last name in a cell, what should I do?

  #4   Report Post  
Old June 17th 08, 09:00 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,942
Default how do i switch the first and last name in a cell?

hi
an example of your names would have been nice. are the seperated by comma?
if so try this.....
=MID(A6,FIND(",",A6)+2,255)& " "&LEFT(A6,FIND(",",A6)-1)
if not, post some examples of what you are trying to reverse.

Regards
FSt1

"Slac" wrote:

I want to switch a person's first and last name in a cell, what should I do?



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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I switch the order of text entries in a cell? trainer07 Excel Discussion (Misc queries) 3 May 17th 07 03:05 AM
Cannot switch between sheets... Revik Excel Discussion (Misc queries) 0 February 14th 07 03:30 PM
getting excel to switch to a new row caldolegare Excel Worksheet Functions 1 August 30th 05 10:44 AM
switch statement tkaplan Excel Discussion (Misc queries) 1 July 13th 05 08:12 PM
How to switch to edit the cell hon123456 Excel Discussion (Misc queries) 2 January 13th 05 11:40 AM


All times are GMT +1. The time now is 05:33 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017