| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with functions to nest
Im using a formula like this to clean a name in COL A:
=TRIM(SUBSTITUTE(A2,",","")) John , Smith Clean output in COL C is "John Smith" And I also use =RIGHT(C2,LEN(C2)-FIND(" ",C2))&" "&LEFT(C2,SEARCH(" ",C2)-1) to invert the name "John Smith" to "Smith John" What can I do to nest this two Formulas in only one step? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I nest ISTEXT and IF functions? | Excel Worksheet Functions | |||
| nest functions in CELL function | Excel Worksheet Functions | |||
| How do I nest these 3 IF functions? | Excel Worksheet Functions | |||
| Why not nest more than 7 functions in Excel formula??? | Excel Worksheet Functions | |||
| How can I nest more than seven functions in MS Excel? | Excel Worksheet Functions | |||
Threaded Mode
