Combing elements of an array into a single string

[gye325]

Hi everyone,

I would like to combine all elements of an array into a single string. For example, I have an array of 5 string elements

A

B

C

D

E

I would like to merge all the elements to a single string of ABCDE.

I tried using the "Array to Spreadsheet String" function but the separating tabs were causing me a problem even though I removed them with "Search and Replace String"

Thank you in advance for your help.

[Todd_Lesher · Accepted solution]

[gye325]

Thanks!

[johnsold]

Concatenate String will accept an array of strings directly.  No need for the loop.

Lynn

[gye325]

fantastic, even better. thanks!

[Todd_Lesher]

---

@johnsold wrote:

Concatenate String will accept an array of strings directly.  No need for the loop.

Drat! Forgot. Kudos, Lynn.