-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of shyam
Sent: Thursday, December 17, 2009 7:02 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Concatenate after checking all cell
Date at sheet1 Date at sheet2 Date at s
TEXT(IF(ISTEXT(B41)=FALSE,B41,IF(ISTEXT(C41)=FALSE,C41,IF(ISTEXT(D41)=FALSE,DC41,IF(ISTEXT(E41)=FALSE,E41,IF(ISTEXT(F41)=FALSE,F41,IF(ISTEXT(G41)=FALSE,G41,"")),"DD-MMM-")
try this see whether it works for you o
On Fri, Dec 18, 2009 at 10:51 AM, rf1234 rf1234 wrote:
> Dear paul Thanks
Dear paul Thanks For reply.
I know concatenation
=CONCATENATE(B2,C2,D2,E2,F2,G2)
=(B2&""&C2&""&D2&""&E2&""&F2&""&G2)
Will not give the suitable result
As i have already tried.Prblem is that 6 person enter the data for same
client and
now i have to concatenate these report.
As i mension in the ex
Not sure of your meaning..
"concatenate" means to join two strings end-to-end.
so, your first line becomes:
0-Jan-000-Jan-000-Jan-0029-Nov-080-Jan-000-Jan-00
THAT is the meaning of "concatenation".
At first glance, it looks like you're trying to find the maximum
(or latest) date.
However, in your
