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

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

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

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

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