alter_ego1981
Thread Starter
- Joined
- Jun 26, 2008
- Messages
- 49
Hi All,
Hope you can help, I have a slight problem here which my boss thinks can be sorted with a clever macro but I am not to sure.
Basically we have a spreadsheet full of data which are are having to maniplute by hand in the address fields. some of the data lines are ok as they are but others we have to copy and paste into another cell,
i have attached an example, as you can see its a mixture of business name and number in one cell and the rest of the address in another.
Hope you understand and can help.
Thanks
Hope you can help, I have a slight problem here which my boss thinks can be sorted with a clever macro but I am not to sure.
Basically we have a spreadsheet full of data which are are having to maniplute by hand in the address fields. some of the data lines are ok as they are but others we have to copy and paste into another cell,
i have attached an example, as you can see its a mixture of business name and number in one cell and the rest of the address in another.
Hope you understand and can help.
Thanks
Attachments
-
16 KB Views: 82