Log In
Register
Home
July 10, 2019
Offline
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
Trusted Members
December 20, 2019
Offline
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
July 10, 2019
Offline
Thank you
textjoin_old.png worked
textjoin.png came up as #NAME? =TEXTJOIN(",",TRUE,R223:R248)
Trusted Members
December 20, 2019
Offline
textjoin came up with the name error as you must be on an older version of excel
July 10, 2019
Offline
yes 2016
guess I have to upgrade
thanks
VIP
Trusted Members
December 7, 2016
Offline
Here is a good list showing all Excel functions and from which version they are available.
Trusted Members
December 20, 2019
Offline
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
1 Guest(s)
