| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Nesting two functions
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 | |||
| nesting issue in functions | Excel Worksheet Functions | |||
| How do u emulate nesting seven IF functions in a cell? | Excel Worksheet Functions | |||
| Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
| What is the syntax for nesting functions such as IF AND? | Excel Worksheet Functions | |||
| nesting 18 x functions | Excel Worksheet Functions | |||
Threaded Mode
