Show Both in one cell/column

S

something68

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
 
J

Jacob Skaria

Do you mean formula

=E3& " - " & E4

with 'H' in cell E3 and '8' in cell E4

If this post helps click Yes
 
S

Sean Timmons

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))
 
S

something68

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!
 
S

something68

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top