View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kimmie kimmie is offline
external usenet poster
 
Posts: 14
Default USE CONCATENATE function to connect 2 formulas

Is there a way to combine two cells and have it show up with a comma between
the last name and first name:

Phillips Steve

....and make it appear as Phillips, Steve when the name is combined using
this formula:

=CONCATENATE(A1," ",B1) - COMBINE CELLS