SEMICOLONseparated

[Nemojoar10]

Hi! Have a question ...


Say I have some info that I entered in to a excellfil. Example: In column A1, it appears "NAME" so I enter a name in A2. Column B1, it appears "ADDRESS" so I fill in the address in B2, in C1 "TELE Nr" I fill tele Nr in C2. And so I continue with different information to column M. I continue down and fill in the next "person's" name in A3, in B3 address, phone number in C3, etc., etc. ... down to cell 50.

Now I want to get ALL information contained in A2, B2, C2, D2, etc., etc. until M2, in to A2. And all the info in A3, B3, C3, D3 until M3 gathered in A3 etc etc all the way to cell 50. So all the info in each row will be collected in Column A and down.

the thing is now ... I want the information from each column, from A2 up to M2 in A2 but separated with a "SEMICOLON" I want that the information from each column, now to appear in A2 separated by a, (semicolon) ; .

In column A1 will then name, address, phone number, etc. etc. to be separated by a semikoln as below:

name;address;telephone number; (information from A2, A3, A4, A5, etc., etc.) and all the way to the A50, B50, etc..

Please someone who understands this? I Uses Office 2011 on my Mac.

Thanks in advance!