LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
show last used cell in a column at the bottom of column. dsharris59 Excel Worksheet Functions 3 February 4th 09 07:09 PM
lookup specific value in a column and show it in a new cell Piotr (Peter)[_2_] Excel Worksheet Functions 3 September 5th 08 09:02 AM
Show the latest Cell Value of a column in the other cell of worksh Amir Excel Worksheet Functions 2 May 8th 07 03:15 AM
Show the latest Cell Value of a column in the other cell of worksh Amir Excel Worksheet Functions 1 May 7th 07 08:21 PM
Show the latest Cell Value of a column in the other cell of worksh Amir Excel Worksheet Functions 0 May 7th 07 08:03 PM


All times are GMT +1. The time now is 01:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"