I would like to auto generate a reference number using the name entered, date, and page number from a guide.
For example,
John Smith
2/21/2012
pg. 158
would come out to
JS-02212012-158
Is there any possible way to have this number auto generate when information is input?
Last edited by cody1187; 02-21-2012 at 02:27 PM.
Is the name, date and page in 1 cell or separated to 3 cells?
Quang PT
Say they are in A1:A3 try:
=LEFT(A1,1)&MID(A1,FIND(" ",A1)+1,1)&"-"&TEXT(A2,"MMDDYYYY")&"-"&RIGHT(A3,LEN(A3)-FIND(" ",A3))
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
I get an error "a value used in the formula is of the wrong data type"
Name, date, and pg# are each different cells.
Try this:
in which date issue is treated as Text with 8 digits
Please Login or Register to view this content.
Thanks All
I messed up in my example the page # is in just a number "158" not "pg. 158"
after i changed the formula it works perfectly
No worries.
Dom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks