| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Data order in Cells
Can someone please help me create a formula that will do
the following... change a cell from: doe,john to john,doe |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing Data order in Cells
Try:
=MID(A1,FIND(",",A1)+1,LEN(A1)-FIND(",",A1)+1)&", "&LEFT(A1,FIND(",",A1)-1) with a1 = Doe, John HTH "Adam Morgan" wrote in message ... Can someone please help me create a formula that will do the following... change a cell from: doe,john to john,doe |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing Data order in Cells
Or, you might like:
=RIGHT(A1, LEN(A1)-FIND(",",A1,1))&","&LEFT(A1,FIND(",",A1,1)-1) (A1 contains john,doe) HTH, Shockley "Adam Morgan" wrote in message ... Can someone please help me create a formula that will do the following... change a cell from: doe,john to john,doe |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change series plotting order without changing legend order? | Charts and Charting in Excel | |||
| copy cells down a column (in order) to across a row (same order?? | Excel Discussion (Misc queries) | |||
| How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
| Can I reverse the order of data in a set of cells? | Excel Discussion (Misc queries) | |||
| changing name order | New Users to Excel | |||
Linear Mode
