Concatenate various cells in one organized by column


Posted by nicolas on November 13, 2001 12:42 AM

Dear Mr Excell,

I am looking to concatenate various cells of the same line in one cell (Call it AA1). The hard part for me is to "make" column of the exact same space for each cells text in that cell(AA1).

ex : A B C
1. November tuesday 11
2. May Wednesday 14

We know that cell A is at most 15 spaces length, colum B is 10 and column C is 2. I am trying to have 1 organized cell with 15 spaces for A1 (Even if the word in A1 is less than 15 spaces), 10 for B1 and 2 for C1.

I am trying to do this for every line.

Could you help? I ve been through your site, it's impressive! but I couldn't find what I was looking for

Nicolas

Posted by Aladin Akyurek on November 13, 2001 3:26 AM

=IF(LEN(A1)<15,REPT(" ",15-LEN(A1)),"")&A1&" "&IF(LEN(A1)<10,REPT(" ",10-LEN(B1)),"")&B1&" "&IF(LEN(A1)<2,REPT(" ",2-LEN(C1)),"")&C1

Aladin

==============



Posted by nicolas on November 13, 2001 4:23 AM

Thanks a lot Aladin