| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rearrange text
I need to flip the names in several cells...is there a formula or trick to
avoid doing it manually? I have the names set up as (Thomas, John) but need them all to look like (John Thomas). |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
rearrange text
I think it was "Daddylonglegs" that posted this approach:
With A1: Public, John Q. B1: =MID(A1&" "&A1,FIND(",",A1)+2,LEN(A1)-1) If extra spaces may be a problem: B1: =TRIM(MID(A1&" "&A1,FIND(",",A1)+2,LEN(A1)-1)) Either way returns John Q. Public Does that help? *********** Regards, Ron XL2002, WinXP-Pro "JJ" wrote: I need to flip the names in several cells...is there a formula or trick to avoid doing it manually? I have the names set up as (Thomas, John) but need them all to look like (John Thomas). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extra help with transpose | Excel Discussion (Misc queries) | |||
| Shade cell according to text? | Excel Discussion (Misc queries) | |||
| Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
| SUMPRODUCT vs Text??? | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
