View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] fher_182@hotmail.com is offline
external usenet poster
 
Posts: 1
Default 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?