Hi,
I’m trying to CONCATENATE a sentence in cell w58, a date in w57 and then another sentence in w59. If I do =CONCATENATE(W58&TEXT(C18," mmmm d, yyyy")) I can get the first sentence and the date, I can’t figure out how to add that third string of text
Example
W57 March 1, 2014
W58 hello, today is
W59 I will be in the office all day
Can anyone help?
Dave
You don't always have to spell out your concatenation. The & sign does the exact same thing between expressions.
=W58 & TEXT(C18," mmmm d, yyyy") & " " & W59
Notice, I just manually concatenated a " " in between strings to add a space so it's not all jammed together.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
=W58&TEXT(C18," mmmm d, yyyy ") &W59
You have the choice of using & or concatenate
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
With the example given, the Concatenate function can be used like this......
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
that did it, thank you all :-)
Dave
You're welcome. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks