I need some help combining two columns. But I want to keep the data in column A, and also the date data in column B. I've tried the standard code of "=A1&","&B1" but it converts the date into different numbers.
I have attached a shortened example if that helps.
Thanks
try this one
=A1&" "&TEXT(B1,"dd-mm-yyyy")
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Works perfect I knew I was just missing a minor details I tried several different things. Thank you very much!!!!
Thanks for the reply.
Glad I could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks