CODEWITHSUNDEEP
vbaexcel
KHORBS
KHORBS

Reputation: 1

How to generate a string based on multiple different values?

I'm currently working on a library system on Excel with VBA and I need a function to generate a book's call number based on its title, author and the date.

Here's an example of my coding

dim title, author, date, callnumber as string

title = "Book 1"
title = UCase(title)
author = "Author 1"
author = UCase(author)
date = NOW()

'i'll need to generate the call number
callnumber = ............??????????

Using the above examples, the program should generate a call number for the book based on the author, title, and the date. I would prefer it to have the first 3 letters of the "author", hyphen "-", first 3 letters of "title", hyphen "-", and the date in numbers.

For example if the date is 3 March 2011, the generated call number would be : "AUT-TIT-03032011"

For date = "29 February 2012, title = "The Stickman", author = "John Lee", the generated value should be: "JOH-THE-29022011"

Can someone please help me? Thanks a lot!

Upvotes: 0

Views: 84

Answers (1)

Mohamed Saligh
Mohamed Saligh

Reputation: 12349

callnumber = MID(author,1,3)&"-"&MID(title,1,3)&"-"&Format(date, "ddmmyyyy")

Upvotes: 3

Related Questions