| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reverse Text in Cell before and after comma (not just Word1, Word2
I've seen some workarounds for doing
Smith, John to John Smith But I am looking for Word1 MaybeWord2-3, WordA MaybeWordB-C i.e. just put all the words after the comma in front and vice versa e.g. Assistant Manager, Building Services=Building Services Assistant Manager Manager, Building Services = Building Services Manager Assistant Manager, Building = Building Assistant Manager Is there an 'easy' way to do this with cell functions vs VBA? Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove comma and text past it in cell | Excel Discussion (Misc queries) | |||
| reverse cursor/text direction within cell | Excel Discussion (Misc queries) | |||
| How to Reverse Contents in an Excel cell (Text or a Number) | Excel Worksheet Functions | |||
| REVERSE SINGLE CELL TEXT STRING | Excel Worksheet Functions | |||
| Formula for adding a comma in front of text in a cell | Excel Worksheet Functions | |||
Threaded Mode
