Good day,
This is my first post on this forum so a quick hello from me
I've quite hastily been learning excel over the past few days (managed to go 23 years without really using it) and am finding a few difficulties.
At the moment i'm trying to set the header of my document to be a concatination of the text from several cells.
i.e. Project Name = A14, Project Number = B14, Project Date = C15
I would like the header to be something along the lines of:
B14 & " " & A14 & " on " & C15
I hope this makes sense, as i say i have little knowledge on excel at the moment but am eager to learn quickly
Spunky
How I suggest you do this is by putting this in A1
=B14&" "&A14&" on "&TEXT(DATE(YEAR(C15),MONTH(C15),DAY(C15)),"dd/mm/yyyy")
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Thank you, i had a feeling i might have to do it like that.
If i can ask another quesiton, the cells i'm referencing are on another static named sheet "Details". Is there a way to reference things like Sheets("Details").cells(B15) and such to give the same header as you have provided?
Yes you can do that to with this, just add the sheet name followed by !
=Details!A14&" "&Details!B14&" on "&TEXT(DATE(YEAR(Details!C15),MONTH(Details!C15),DAY(Details!C15)),"dd /mm/yyyy")
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Had some trouble with some merged fields but just worked out how to get around that. Thanks alot, looks the part now
Glad to hear you're sorted - thanks for the feedback
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks