Previous Topic Next Topic

Excel - A macro to re-arrange cells

Closed
Sikhama Posts 1 Registration date Wednesday 13 August 2014 Status Member Last seen 13 August 2014 - 13 Aug 2014 à 04:06
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 14 Aug 2014 à 01:51
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.
Related:

1 response

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
14 Aug 2014 à 01:51
download sample file

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

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

Similar discussions

Lenovo Laptop blinking keys but no display
What123What -
What123What -

5 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
How to make a cell blink in "Excel"?
JohnDohe -
ac3mark -

16 responses
Convert number to spelling
Sukumar -
mrwagh85 -

28 responses