Good morning,
How do I insert - (dash) between numbers in my existing formula?
I appreciate your help so much.
Thank You
Good morning,
How do I insert - (dash) between numbers in my existing formula?
I appreciate your help so much.
Thank You
What do you mean? A dash where? There is only one number. Give us an example.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
This ??
="Week of " &TEXT(MID(CELL("Filename",J1),FIND("]",CELL("Filename",J1))+1,31),"00-00-00") &" "& "Shipment"
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Excellent John that's the number I would like to add - dash between.
How do I convert those number to date in MMM-DD-YY format?
I tried replacing 00-00-00 to MMM-DD-YY but it gives me date like Dec-09-74 instead of today's date.
your help is very much appreciated.
Thank You.
Try
="Week of "&TEXT(DATEVALUE(TEXT(MID(CELL("Filename",J1),FIND("]",CELL("Filename",J1))+1,31),"00-00-00")),"mmm-dd-yy") &" "&"Shipment"
Excellent john.
Thank you and appreciate your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks