Hello,
I'm a photographer and like to make pass words for my clients that begin withe the first letters of their names and with their client numbers, i have a list of numbers and names made up in excel and want to automate the extraction of passwords... is there a formula anyone knows to make my life easier, its a lot of clients that have to have pass words?
who can help me
greetings from a sunny amsterdam , holland
Assuming names in column A & ID numbers in column B
enter this formula in another column
eg c1
=LEFT(A1,1)&B1
drag formula down
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
how do you want first letters of names?
martin wilson becomEs mar ? then a simple =left(A1,3)&B1 in cell C1 will add those letters to a number in B1
eg mar123456
but if you want a bit of first and a bit of last e.g MAWI123456
then you have to start extracting stuff for that example you'd use
=LEFT(A1,2)&MID(A1,FIND(" ",A1)+1,2)&B1
Last edited by martindwilson; 05-07-2009 at 08:24 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks