Formula Streamline

[Biz]

Dear All,

Is it possible to make a more simplier formula per desired results col E?

Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 116px"><COL style="WIDTH: 58px"><COL style="WIDTH: 75px"><COL style="WIDTH: 64px"><COL style="WIDTH: 132px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Payment Amount</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">supplier</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Date</TD><TD> </TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Desired Solution</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: center">500</TD><TD style="TEXT-ALIGN: center">NEL</TD><TD style="TEXT-ALIGN: center">12/07/11</TD><TD> </TD><TD>500 / NEL / 12/07/11</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: center">100</TD><TD style="TEXT-ALIGN: center">PRE</TD><TD style="TEXT-ALIGN: center">21/07/11</TD><TD> </TD><TD>100 / PRE / 21/07/11</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: center">200</TD><TD style="TEXT-ALIGN: center">TUR</TD><TD style="TEXT-ALIGN: center">03/08/11</TD><TD> </TD><TD>200 / TUR / 03/08/11</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>E2</TD><TD>=A2&" / "&B2&" / "&TEXT(C2,"dd/mm/yy")</TD></TR><TR><TD>E3</TD><TD>=A3&" / "&B3&" / "&TEXT(C3,"dd/mm/yy")</TD></TR><TR><TD>E4</TD><TD>=A4&" / "&B4&" / "&TEXT(C4,"dd/mm/yy"</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Biz

 

[jbeaucaire]

That appears perfect to me.

 

[Biz]

Thanks m8

 

[Jerry Sullivan]

Hi Biz,

Your formula is already pretty simple for a result that has 5 parts to it.

If you formatted Column B as text, you could do this...
=A2&" / "&B2&" / "&C2

But that is generally a bad idea.

I agree with Jerry B that what you have is perfect.