| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change order of string
In A1 I have the string DOE, JOHN PETER MR (SEE SMITH)
What I would like to do is compose a formula that can reorder this string to read MR JOHN PETER DOE (SEE SMITH) However note that MR could be MRS, MS or DR. That is A1 might contain DOE, JANE SALLY MS (SEE SMITH) Can someone help me here please. |
| 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 | |||
| changing the order of text in a string | New Users to Excel | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| Change tab order from left right to down and across | Excel Discussion (Misc queries) | |||
| Reversing the Order of a String | Excel Worksheet Functions | |||
Threaded Mode
