View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
something68 something68 is offline
external usenet poster
 
Posts: 38
Default 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