Bigger Problem
Having got all my e-mail addresses into " format i now need to
sort them into a single cell. This cannot be more than 250 characters long. The e-mail addresses need to be sorted by code. Addresses: Code E-mail 111 111 111 111 111 111 111 111 111 111 111 111 112 112 112 112 112 112 I need the e-mail addresses to be put into 1 cell, with the code in say A2 and the e-mail addresses in B2. I need them seperated by commas. I also need B2 to be no more than 250 characters. If it is i need the rest of the e-mails to be put in B3 up to 250 characters and the code to be put in A3. Once all the e-mail addresses have been put in a list then i need the start on the ones with a different code. Example: A2 = 111 B2 = , ,upto 250 characters. A3 = 111 B3 = ,upto 250 characters A4 = 112 B4 = , ,upto 250 characters No spaces. I'm having real trouble doing this, If it was in macro code it'd be preferable although any help would be appreciated! Thanks N1KO |
All times are GMT +1. The time now is 09:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com