| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show Both in one cell/column
Cell E3 shows H and E4 shows 8; Cell E3 shows SP and E4 shows 8
How can I show BOTH H 8 and SP 8 in column U? i.e. Column U3: H, SP Column U4: 8, 8 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show Both in one cell/column
Do you mean formula
=E3& " - " & E4 with 'H' in cell E3 and '8' in cell E4 If this post helps click Yes --------------- Jacob Skaria "something68" wrote: Cell E3 shows H and E4 shows 8; Cell E3 shows SP and E4 shows 8 How can I show BOTH H 8 and SP 8 in column U? i.e. Column U3: H, SP Column U4: 8, 8 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show Both in one cell/column
I'm afraid I may not be explaining what I need very well. I am simply trying
to show two different leave times in one cell - ex. H, AL on one row and 4, 8 on the next row. Thanks anyway! "Jacob Skaria" wrote: Do you mean formula =E3& " - " & E4 with 'H' in cell E3 and '8' in cell E4 If this post helps click Yes --------------- Jacob Skaria "something68" wrote: Cell E3 shows H and E4 shows 8; Cell E3 shows SP and E4 shows 8 How can I show BOTH H 8 and SP 8 in column U? i.e. Column U3: H, SP Column U4: 8, 8 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show Both in one cell/column
OK, Thinking soem cells got mixed up here...
Are H and SP both in E3? And 8 is in E4 twice?? if all 4 values below are in separate cells, just use & =E3&" - "&E4 If E3 has, say, H SP Then =LEFT(E3,FIND(" ",E3)-1)&" - "&LEFT(E4,FIND(" ",E4)-1) =RIGHT(E3,LEN(E3)-FIND(" ",E3))&" - "&RIGHT(E4,LEN(E4)-FIND(" ",E4)) "something68" wrote: Cell E3 shows H and E4 shows 8; Cell E3 shows SP and E4 shows 8 How can I show BOTH H 8 and SP 8 in column U? i.e. Column U3: H, SP Column U4: 8, 8 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show Both in one cell/column
I'm afraid it didn't help. This is a bit more complicated than I thought and
I may not be explaining what I want very well. Sorry. There are no cells "mixed up". I simply want to show two separate leave times (ex. H and AL) and the hours for each (ex. 4 and 8, respectively) all in one column/cell. Thanks anyway! "Sean Timmons" wrote: OK, Thinking soem cells got mixed up here... Are H and SP both in E3? And 8 is in E4 twice?? if all 4 values below are in separate cells, just use & =E3&" - "&E4 If E3 has, say, H SP Then =LEFT(E3,FIND(" ",E3)-1)&" - "&LEFT(E4,FIND(" ",E4)-1) =RIGHT(E3,LEN(E3)-FIND(" ",E3))&" - "&RIGHT(E4,LEN(E4)-FIND(" ",E4)) "something68" wrote: Cell E3 shows H and E4 shows 8; Cell E3 shows SP and E4 shows 8 How can I show BOTH H 8 and SP 8 in column U? i.e. Column U3: H, SP Column U4: 8, 8 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show last used cell in a column at the bottom of column. | Excel Worksheet Functions | |||
| lookup specific value in a column and show it in a new cell | Excel Worksheet Functions | |||
| Show the latest Cell Value of a column in the other cell of worksh | Excel Worksheet Functions | |||
| Show the latest Cell Value of a column in the other cell of worksh | Excel Worksheet Functions | |||
| Show the latest Cell Value of a column in the other cell of worksh | Excel Worksheet Functions | |||
Hybrid Mode
