View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Footlight Footlight is offline
external usenet poster
 
Posts: 1
Default how do i add commas in a single cell?

okay, so i have a single line of imported addresses where the entire address
is in one cell. I don't want to move cities, etc. to another cell; I just
want to add comma's in the appropriate places. Is there a way to do that?

i.e. :

Cell A1
123 Anywhere St Somewhere in US 12345

Becomes:

Cell A1
123 Anywhere St, Somewhere in US, 12345