Jagwarman
asked on
Text and date formula
I have attached a spreadsheet that should explain what I am trying to do which is:
I want to concatenate text and date, but the date needs to be like 1st Aug 16, 2nd, 3rd, 4th Aug 16 etc so not like 1/8/16, 1 Aug 16 or 1-8-16
So, Collections JK13 would become Collections BH13 24th Aug 16 after concatenation
dates-and-text.xlsx
I want to concatenate text and date, but the date needs to be like 1st Aug 16, 2nd, 3rd, 4th Aug 16 etc so not like 1/8/16, 1 Aug 16 or 1-8-16
So, Collections JK13 would become Collections BH13 24th Aug 16 after concatenation
dates-and-text.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@Jagwarman
I assume that compliment is for both of us. Right? :)
I assume that compliment is for both of us. Right? :)
ASKER
Subodh Tiwari (Neeraj) they all work for me and so do yours
thanks
thanks
ASKER
yes brilliant both of you many thanks
ASKER
thanks guys
You're welcome. Glad we could help.
thanks Jagwarman
thanks Neeraj :)
thanks Neeraj :)
ASKER