You're welcome..........thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3



"jelm" wrote:

Super!! Thanks.

"CLR" wrote:

='Doe, Jane'!AR6&" "&'Smith, Jane'!AR6&" "&'Smith, Joe'!AR6

or

='Doe, Jane'!AR6&", "&'Smith, Jane'!AR6&", "&'Smith, Joe'!AR6

or whatever other seperator you might desire...you get the idea.

Vaya con Dios,
Chuck, CABGx3



"jelm" wrote:



"jelm" wrote:

I need to add a space between data in a cell that is coming from multiple
links.

='Doe, Jane'!AR6&'Smith, Jane'!AR6&'Smith, Joe'!AR6

What is entered in AR6 of each sheet is that person's name, Jane Doe etc...
The names are appearing in the linked cell as JaneDoeJaneSmithJoeSmith. Is
there a way to space names?