add space between data from multiple links in a cell
 

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

add space between data from multiple links in a cell
 

=A1&" "&B1
--
David Biddulph

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

add space between data from multiple links in a cell
 

Please post your formula or links you are wanting to separate.......someone
will help

Vaya con Dios,
Chuck, CABGx3



"jelm" wrote:

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

add space between data from multiple links in a cell
 

"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?

add space between data from multiple links in a cell
 

='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?

add space between data from multiple links in a cell
 

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?

add space between data from multiple links in a cell
 

Super!! Thanks.

"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?

add space between data from multiple links in a cell
 

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?