| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing paste order
Hi,
If I copy Haig Paul into a single cell but want it to read Paul Haig in the cell or 2 cells what do I have to do? It has a comma VMT Paul |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing paste order
Hi Paul,
You can use following formula, if you have this data in cell A1:- =MID(A1,FIND(",",A1)+1,LEN(A1)-FIND(",",A1))&" "& MID(A1,1,FIND(",",A1)-1) Thanks & Regards, -- Dilip Kumar Pandey MBA, BCA, B.Com(Hons.) New Delhi, India "Paul" wrote: Hi, If I copy Haig Paul into a single cell but want it to read Paul Haig in the cell or 2 cells what do I have to do? It has a comma VMT Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
| In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
| Changing text order | Excel Discussion (Misc queries) | |||
| changing name order | New Users to Excel | |||
| Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions | |||
Linear Mode
