Posted to microsoft.public.excel.worksheet.functions

NSNR[_2_]

external usenet poster

Posts: 5

Concatenate function

Hi,
How can I concatenate these 2 cells: one is time and the other is text: 9:00
and AM and I want the result to be 9:00 AM
=CONCATENATE(AD2, " ", AE2)
I have tried different formating cells but it doesn't work, this is what I
get:
0.375 AM

Thanks for your help.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Concatenate: in an IF Function	Tracey	Excel Worksheet Functions	6	March 16th 09 05:13 PM
Using the concatenate function	BIAKathy	Excel Discussion (Misc queries)	3	January 8th 09 11:46 PM
CONCATENATE FUNCTION!	pyager	Excel Worksheet Functions	4	September 29th 08 05:12 PM
CONCATENATE/& Function ?	Ash	Excel Discussion (Misc queries)	5	February 23rd 07 04:57 PM
Concatenate Function	BenG	Excel Discussion (Misc queries)	3	September 21st 06 10:08 PM

All times are GMT +1. The time now is 02:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us