| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| links initiated by cell data | Excel Discussion (Misc queries) | |||
| Discovering No-BREAK Space in cell Data | Excel Discussion (Misc queries) | |||
| VBA to parse multiple links to one cell | Excel Discussion (Misc queries) | |||
| Links (multiple) to Imbedded W/S in adjacent cell | Excel Discussion (Misc queries) | |||
| Maintain cell links when renaming directory containing multiple f | Excel Worksheet Functions | |||
Linear Mode
