JOIN Command Issue

Getting a #unparseable error with the following Join command below. I want to combine ten different comment cells and join them under another separate Comment cell.

=JOIN([Comments #1]1:[Comments #2]1:[Comments #3]1:[Comments #4]1:[Comments #5]1:[Comments #6]1:[Comments #7]1:[Comments #8]1:[Comments #9]1:[Comments #10]1, "." )

See attached screenshot.

Any assistance would be much appreciated.

Find more posts tagged with

Sheets

Formulas

Support

Comments

Andrée Starå

Hi Bruce,

Try something like this.

=JOIN([Comments #1]@row:[Comments #10]@row; ".")

The same version but with the below changes for your and others convenience.

=JOIN([Comments #1]@row:[Comments #10]@row, ".")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.