Excel - A macro to re-arrange cells

Closed
Sikhama Posts 1 Registration date Wednesday August 13, 2014 Status Member Last seen August 13, 2014 - Aug 13, 2014 at 04:06 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 14, 2014 at 01:51 AM
I need your help to solve the following problem.

I have files containing data about key contacts of company. Company Name,Concerned Person,Designation,Contact Number,Email Id.

I need a macro which which can arrange the cells in the following way

Accubid Giovanni Marcelli President 1.905.761.8800 gmarcelli@accubid.com

I will be very grateful to you for this help.

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Aug 14, 2014 at 01:51 AM
download sample file

http://speedy.sh/Mbvu9/SIKHAMA-140814.xlsx

see the revised format and formula in A10 which is copied down
0