An Easy One - Creating Usernames

Maureen5433

Board Regular
Joined
May 13, 2002
Messages
111
Office Version
  1. 365
Platform
  1. Windows
I know this is probably easy and I think I am making it too hard. I need to create a list of passwords based upon a couple of things:

Username format is as follows: um0005
The first two letters will always be um. There is a list of numbers going up to 3 digits that the usernames are based upon. Username should never exceed the um+4 #s. So they would be as follows:

5 = um0005
21 = um0021
100 = um0100

The base # is found in column A - that is only "data" I actually have to generate the username.

Again - feel like I am overthinking this one. Any ideas?
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Forum statistics

Threads
1,224,609
Messages
6,179,882
Members
452,948
Latest member
Dupuhini

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top