I want to be able to make my job easier at work. I need to be able to do the following. ex. Valeriano, Bruno D
For the above last name, first name space Middle I I need to be able to copy from a web site and it show in another cell the customer the first 6 char of there last name, first letter of there fist name + middle I. How would I do that? For the above ex the answer would be ValeriBD
For the above last name, first name space Middle I I need to be able to copy from a web site and it show in another cell the customer the first 6 char of there last name, first letter of there fist name + middle I. How would I do that? For the above ex the answer would be ValeriBD