| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I switch the order of text entries in a cell?
,I have peoples' names listed in the cells in column A. For example, in cell
A1, I have: Brown, Jane I would liike the name to read: Jane Brown (switch the first and the last name order and remove the comma). Is there a way to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I switch the order of text entries in a cell?
=REPLACE(A1&" "&LEFT(A1,FIND(",",A1)-1),1,FIND(",",A1)+1,"")
-- Gary''s Student - gsnu200722 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I switch the order of text entries in a cell?
[off topic] - Gary, did you see this?
http://www.microsoft.com/office/comm...xp=&sloc=en-us Mike Fosmire [MSFT] needs to get in touch with you. "Gary''s Student" wrote: =REPLACE(A1&" "&LEFT(A1,FIND(",",A1)-1),1,FIND(",",A1)+1,"") -- Gary''s Student - gsnu200722 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I switch the order of text entries in a cell?
Thanks, I'll contact him offline
-- Gary''s Student - gsnu200722 "JLatham" wrote: [off topic] - Gary, did you see this? http://www.microsoft.com/office/comm...xp=&sloc=en-us Mike Fosmire [MSFT] needs to get in touch with you. "Gary''s Student" wrote: =REPLACE(A1&" "&LEFT(A1,FIND(",",A1)-1),1,FIND(",",A1)+1,"") -- Gary''s Student - gsnu200722 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set a column to list entries in Alphabetic order? | Excel Worksheet Functions | |||
| switch number order | Excel Worksheet Functions | |||
| What buttons do I need to push in order to switch between sheets? | Excel Worksheet Functions | |||
| Is there a way to switch name order in an Excel column? | Excel Discussion (Misc queries) | |||
| How do I change the order of the legend entries? | Charts and Charting in Excel | |||
Linear Mode
