Thread
:
How do I add a comma between a range of cells?
View Single Post
#
3
Posted to microsoft.public.excel.setup
Roger Govier
external usenet poster
Posts: 2,886
How do I add a comma between a range of cells?
Hi
assuming the concatenated string is in A1
=SUBSTITUTE(A1,"-",",")
--
Regards
Roger Govier
"AZ ChrisD" <AZ
wrote in message
...
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
Reply With Quote
Roger Govier
View Public Profile
Find all posts by Roger Govier