D Dennis Oct 1, 2003 #2 I'm not sure if this is what you're asking, but it will put a comma in any cell that is selected. Sub Comma() Selection.FormulaR1C1 = "," Range("A1").Select End Sub Dennis ============
I'm not sure if this is what you're asking, but it will put a comma in any cell that is selected. Sub Comma() Selection.FormulaR1C1 = "," Range("A1").Select End Sub Dennis ============
U Ulti Oct 1, 2003 #3 If the names are in seperate cells, you can use the & key to combine them with a ,. Nicole is in A1 and Anna is in A2. +a1&", "&a2.
If the names are in seperate cells, you can use the & key to combine them with a ,. Nicole is in A1 and Anna is in A2. +a1&", "&a2.
B Brad E Oct 1, 2003 #4 =TRIM(REPLACE(A1,FIND(" ",A1),1,",")) will put a comma after the first set of characters, then will get rid of unwanted spaces. This only works correctly if the first character of the cell (A1) is not a space.
=TRIM(REPLACE(A1,FIND(" ",A1),1,",")) will put a comma after the first set of characters, then will get rid of unwanted spaces. This only works correctly if the first character of the cell (A1) is not a space.
