Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display issues
Ok, I've set up multiple work sheets in a work book and have referenced cells
from, we'll call it worksheet 1, on worksheet three. I have them showing up in the cell, however I am referencing three different cells from worksheet 1 into one cell in worksheet three and I am not sure how to get them to display with spaces between them. If any body has any ideas I would be most appreciative. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display issues
if you mean somthing like rrr sss ttt
then =sheet1!A1&" "&sheet1!A2&" "&sheet1!A3 if you want it like rrr sss ttt then =sheet1!A1&char(10)&sheet1!A2&char(10)&sheet1!A3 if you want it as rrr sss ttt then sheet1!A1&char(10)&char(10)&sheet1!A2&char(10)&cha r(10)&sheet1!A3 "vronron" wrote: Ok, I've set up multiple work sheets in a work book and have referenced cells from, we'll call it worksheet 1, on worksheet three. I have them showing up in the cell, however I am referencing three different cells from worksheet 1 into one cell in worksheet three and I am not sure how to get them to display with spaces between them. If any body has any ideas I would be most appreciative. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display issues
Click in the cell on Sheet3 that will receive the data from Sheet1.
Type in an equal sign ( = ), Navigate to Sheet1, and click in the first cell containing the data, *IN THE FORMULA BAR*, type this at the end of what you see displayed the &" "& so that it might look like this: =Sheet1!A1&" "& Then, click in the 2nd cell of data, and add the same characters, to look like this: =Sheet1!A1&" "&Sheet1!C1&" "& Finally, click in the final cell, and hit <Enter, and it should look like this: =Sheet1!A1&" "&Sheet1!C1&" "&Sheet1!E1 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "vronron" wrote in message ... Ok, I've set up multiple work sheets in a work book and have referenced cells from, we'll call it worksheet 1, on worksheet three. I have them showing up in the cell, however I am referencing three different cells from worksheet 1 into one cell in worksheet three and I am not sure how to get them to display with spaces between them. If any body has any ideas I would be most appreciative. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display issues
Thanks! I knew it had something to do with quotations but the things I tried
weren't working and my brain was just refusing to cope. "Ragdyer" wrote: Click in the cell on Sheet3 that will receive the data from Sheet1. Type in an equal sign ( = ), Navigate to Sheet1, and click in the first cell containing the data, *IN THE FORMULA BAR*, type this at the end of what you see displayed the &" "& so that it might look like this: =Sheet1!A1&" "& Then, click in the 2nd cell of data, and add the same characters, to look like this: =Sheet1!A1&" "&Sheet1!C1&" "& Finally, click in the final cell, and hit <Enter, and it should look like this: =Sheet1!A1&" "&Sheet1!C1&" "&Sheet1!E1 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "vronron" wrote in message ... Ok, I've set up multiple work sheets in a work book and have referenced cells from, we'll call it worksheet 1, on worksheet three. I have them showing up in the cell, however I am referencing three different cells from worksheet 1 into one cell in worksheet three and I am not sure how to get them to display with spaces between them. If any body has any ideas I would be most appreciative. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display issues
Appreciate the feed-back.
-- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "vronron" wrote in message ... Thanks! I knew it had something to do with quotations but the things I tried weren't working and my brain was just refusing to cope. "Ragdyer" wrote: Click in the cell on Sheet3 that will receive the data from Sheet1. Type in an equal sign ( = ), Navigate to Sheet1, and click in the first cell containing the data, *IN THE FORMULA BAR*, type this at the end of what you see displayed the &" "& so that it might look like this: =Sheet1!A1&" "& Then, click in the 2nd cell of data, and add the same characters, to look like this: =Sheet1!A1&" "&Sheet1!C1&" "& Finally, click in the final cell, and hit <Enter, and it should look like this: =Sheet1!A1&" "&Sheet1!C1&" "&Sheet1!E1 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "vronron" wrote in message ... Ok, I've set up multiple work sheets in a work book and have referenced cells from, we'll call it worksheet 1, on worksheet three. I have them showing up in the cell, however I am referencing three different cells from worksheet 1 into one cell in worksheet three and I am not sure how to get them to display with spaces between them. If any body has any ideas I would be most appreciative. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TODAY() issues | Excel Worksheet Functions | |||
Subtotal issues | Excel Discussion (Misc queries) | |||
Display Issues with X-Axis | Charts and Charting in Excel | |||
display issues | Excel Discussion (Misc queries) | |||
Data Issues | Excel Worksheet Functions |