Need help urgently...

[Khairol]

Hi all..

Sorry to say that I need to pick your brains regarding excel and VBA. I have a problem, I need to convert 20+ excel files into CSVs. These CSVs then have to be imported to creat e-mail accounts (students'). However the arrangement of the data in the excel files are not suitable for CSV import so I have to modify them. Now living in Asia, we don't have firstnames nor surnames. Therefore these students' name are to be truncated. An example of this will be:

Muhammad Ali bin Bahar will become ali.bahar@xxxxxxxx.xxxx.edu
Lim Xie Xie will become xiexie.lim@@xxxxxxxx.xxxx.edu

Now I am doing it manually, is there VBA experts out there that can help with my problem.

Thanks In Advance

 

[Weaver]

There's a fair bit of diversity, even in just those two examples you've quoted. What's the criteria for deciding which parts of the name to build the email address from?

 

[Khairol]

There's a fair bit of diversity, even in just those two examples you've quoted. What's the criteria for deciding which parts of the name to build the email address from?

Thank you for the question,

I tend to ignore common names such as Muhammad, Haji, Hajah, Awang, bin or binti and so on.

So if it is Muhammad Ali bin Bahar, I am getting ali bahar as the text for CSV. I don't know how to do this yet so I am doing it manually. However I know how to merge those two words so that they come ali.bahar and then add the @ address. For the chinese name, I am doing it manually

-K

 

[Weaver]

In order to automate this process, you'd need a much tighter set of rules. How about an exception list, of names/name parts you wouldn't include?

 

[mattrx731]

How about find/replace and getting rid of the 'common' names, and then building the email address from that... Not completely automated, but it may be quicker than what he is doing now...

 

[Khairol]

How about find/replace and getting rid of the 'common' names, and then building the email address from that... Not completely automated, but it may be quicker than what he is doing now...

Hi guys, thanks for the input. Done that just by doing a simple exception rule. So adding @ is the problem now. LOL.. I guess it is Typinator™ time.