Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I run a macro and it puts these values in cells D1 to N1. This can be longer or shorter but the format stays the same for the single letters & numbers following the word in D1 ("Abit" here).
Abit A 9 B 8 C 7 D 6 E 5 Then thecode below is called and I get this ALL IN ONE CELL, D1. Abit A 9 B 8 C 7 D 6 E 5 Sub ConIt() Dim i As Integer i = ActiveSheet.Cells(1, Columns.Count).End(xlToLeft).Column - 3 For i = 1 To i Range("D1").Value = Range("D1").Value & " " & Range("D1").Offset(0, i) Next End Sub How can I make the code put a coma after each number EXCEPT the last number which is 5 here. Thanks, Howard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
number seperator by coma | Excel Programming | |||
Coma between two e-mails | Excel Discussion (Misc queries) | |||
Coma Separator in Numbers | Excel Discussion (Misc queries) | |||
coma not separating data | Excel Discussion (Misc queries) | |||
Indian Coma Style | Excel Programming |