View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
AZ ChrisD AZ ChrisD is offline
external usenet poster
 
Posts: 1
Default How do I add a comma between a range of cells?

Example: I have cells A1 through A70 with data in each cell in the following
format 123-03-123. I need a sting of text returned that will combine the
cells separated by a comma.

Example: 123-34-234,234-23-234,345-23-123, etc...

I need to be able to copy and paste the string in to a websearch that
specifies "separated by commas no spaces"

I know there has to be a simple way to do that but I am a rookie in Excel :(

Thanks for all your help...

Chris