combine data and add extra info

I work in a school setting and we are becoming 1:1. In order to make the process easier for our 3 Tech Advisors, I am trying to make a macro. This macro needs to take from a list of first names (in column B) add a period to the end of it and add it to the matching last name (column A). It would look like this "john.doe". It would need to do this for several hundreds of names. It then needs to take the first letter of the first name and the first letter of the last name and combine them twice. It would look like this "JDJD". Then add this "JDJD" to a pre-assigned 4 digit number (in column C). It would look like this "JDJD1234". So basically I need to take all of this and put it onto a separate workbook with the "john.doe" being in column A, and "JDJD1234" being in column B. But, they would need to stay together. If anybody can help with this it would be spectacular.

Hi, welcome to the forum

I adjusted your title for you.

Do you really need VBA for this?

	A	B	C	D	E
1	Name1	name2		Combo	Add extra
2	aa1	bb1	1234	aa1.bb1	ABAB1234
3	aa2	bb2	1235	aa2.bb2	ABAB1235
4	aa3	bb3	1236	aa3.bb3	ABAB1236
5	aa4	bb4	1237	aa4.bb4	ABAB1237
6	aa5	bb5	1238	aa5.bb5	ABAB1238
7	aa6	bb6	1239	aa6.bb6	ABAB1239
8	aa7	bb7	1240	aa7.bb7	ABAB1240
9	aa8	bb8	1241	aa8.bb8	ABAB1241
10	aa9	bb9	1242	aa9.bb9	ABAB1242
11	aa10	bb10	1243	aa10.bb10	ABAB1243
12	aa11	bb11	1244	aa11.bb11	ABAB1244

D2=A2&"."&B2
E2=UPPER(LEFT(A2)&LEFT(B2)&LEFT(A2)&LEFT(B2))&C2
both copied down

Deleted my duplicate post

Based on your PM question...

Can you explain how your explanation works? And how to use it? I would greatly appreciate it.

D2=A2&"."&B2
This is just taking whats in column A, adding a . and then adding what's in column B

E2=UPPER(LEFT(A2)&LEFT(B2)&LEFT(A2)&LEFT(B2))&C2
All this is doing is taking the left-most character from A, adding it to the left-most character from B (twice), then coverting that to UPPER case, and then adding what is in column C

make sense? If not, please ask again

Thanks for the rep