View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bearspa bearspa is offline
external usenet poster
 
Posts: 5
Default Preserve format, right tab using concatenate

I have the following information:

Col A Col B Col C
Smith Bill (510) 424-5654
Johnson Susan (610) 566-5555
Abrahmson Joycelin (212) 555-5555

I want to create Col D as follows:

Smith, Bill (510) 424-5654
Johnson, Susan (610) 566-5555
Abrahmson, Joycelin (212) 555-5555

Plus I need the last names to be in Bold font, and everything is in a
proportional font like Times Roman (I can brute force line up the phone
numbers if I use a font like Courier).

How do I do this, preferably using just formulae, and not visual basic?

TIA