Is there a formula to string multiple cells either work or numbers to one cell
A1 example A1 to = string to look like (12,15,658) - with or without brackets()
A1 pulling from cell B1(12), B2(15), B3(658)
Thanks
Depends what version of excel you are running - Office 365 or 2019 you can use Textjoin and it is perfect for what you are asking
Older versions you would have to manually join, which is okay if you only have a couple of numbers to join
it is also possible to cheat if it is only done occasionally
In the results cell type = then select the range, while in edit mode highlight the formula in the formula bar and press f9 to evaluate the formula, remove the = and the numbers are seperated with a semi colon
I am sure there are other options that i have missed
Thank you
textjoin_old.png worked
textjoin.png came up as #NAME? =TEXTJOIN(",",TRUE,R223:R248)
textjoin came up with the name error as you must be on an older version of excel
yes 2016
guess I have to upgrade
thanks
Here is a good list showing all Excel functions and from which version they are available.
If you cant upgrade then a small macro can do the same thing as textjoin
Sub StringOfNumbtoCell()
Dim NumsRange As Range
Dim NumsCell As Range
Dim D As String
Dim Output As String
D = Range("b1")
Range("d1").ClearContents
Set NumsRange = Range("A:A")
For Each NumsCell In NumsRange
Output = Output & NumsCell & D
If NumsCell = "" Then
Output = Left(Output, Len(Output) - 2)
Range("d1") = Output
Exit Sub
End If
Next NumsCell
End Sub
