Posted to microsoft.public.excel.misc

orquidea

external usenet poster

Posts: 132

Concatenation

Hi

I want to cancatenate 2 columns
A B
10-Jan 40
The result I am getting is "0-Jan", instead of "10-Jan40".

Could anyone let me know how I can fix it.

Thanks
Orquidea

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
Concatenation	Sol	Excel Discussion (Misc queries)	5	October 23rd 07 08:03 AM
Help with Concatenation	Tabit	Excel Worksheet Functions	8	August 17th 07 06:52 PM
Concatenation	Harry	Excel Worksheet Functions	2	July 17th 06 07:17 PM
Concatenation	Ken	Excel Discussion (Misc queries)	1	April 12th 06 11:26 AM
concatenation	mattguerilla	Excel Discussion (Misc queries)	3	January 26th 06 11:47 PM

All times are GMT +1. The time now is 03:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us