Change a list to a text string

[jaypfeffer]

I don't know if I've posted this in the right place but I hope someone can help me.

 

I'd to take a list of names and put them in 1 field with a comma between each name. When I'm done, I need to have several fields of groups of names.

 

For example. From this:

 

Group 1

Name A

Name B

Name C

Name D

Name E

 

Group 2

Name F

Name G

 

Group 3

Name H

Name I

Name J

Name K

 

To this: 

 

Group 1 field: Name A, Name B, Name C, Name D, Name E

Group 2 field: Name F, Name G

Group 3 field: Name H, Name I, Name J, Name K

 

I hope someone can help me. 

 

Feel free to contact me by email if you like: [email protected]

 

Thank you.

[doughemi]

GroupFieldResult = Substitute(GroupList; "¶"; ", ")

 

Assuming GroupList is one field with the list of names.  If each name is in a different field, then you will have to concatenate them with GroupList = List(NameFieldA; NameFieldB;<etc>)

[jaypfeffer]

Thank you very much. I never knew that was there.