G
Guest
I need to add a space between data in a cell that is coming from multiple
links.
links.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
=A1&" "&B1
G
Guest
Please post your formula or links you are wanting to separate.......someone
will help
Vaya con Dios,
Chuck, CABGx3
will help
Vaya con Dios,
Chuck, CABGx3
G
Guest
jelm said: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?
G
Guest
='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
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
G
Guest
Super!! Thanks.
CLR said:='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
G
Guest
Super!! Thanks.
jelm said:='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?
G
Guest
You're welcome..........thanks for the feedback.
Vaya con Dios,
Chuck, CABGx3
Vaya con Dios,
Chuck, CABGx3