Unique ID using Date,Name, Location, and a counter

Hello All,
I have been trying to solve this myself, but have not made any progress. I am trying to create a tracking system and and making a unique ID to do it. I am taking a person's name, their location, the date, and giving them a number at the end.

For example:
Doe,John, Boston, 23 July 2014, 001.
I want the unique id to take the first two of last name (DO), first three of location (BOS), the date (140723), and give them a number, person 1 is 001, person 2 is 002. So I would like the outcome to read DOBOS140723001.

I have been able to get the first part by using =UPPER(LEFT(C3,2)&LEFT(D3,3) but I cannot get the date to correct.

Any help would help me tremendously.

Is all of that data in one cell? Separating it into columns would make it much easier to accomplish your objective.

Sorry, obviously you have it separated. If the date is in Column E, you can change to the desired format using the following:

Formula:

Please Login or Register  to view this content.

You are awesome. It's been awhile since I've used excel. Do you know the easiest formula to use in order to count entries at the end of the current formula? So I have the current formula. What would be the best way to use the COUNT function or is there a better one to use?

Sorry, what exactly are you trying to count?

The number entry. So the first entry would be 001 then 002 then 003. Just looking to add a count feature to the end of the formula.

It'd probably be more complicated than just concatenating the Column that lists the 001, 002, etc., which you can autofill by selecting the first few numbers, clicking on the bottom right-hand corner of the last cell, and dragging down.

Yeah, I was just looking for something other than doing the drag for the autofill, but it might be the easiest way.