Is there a way to skip blank cells in a concatenate formula? I'm not using macros and prefer not to jump into that if possible. Thanks in advance!
Here is my formula:
=CONCATENATE(TEXT(Timecard!J12,"h:mm AM/PM;@"),"-",TEXT(Timecard!J17,"h:mm AM/PM;@"))
**Where "Timecard!J12" and "Timecard!J17" are blank cells
Try using Textjoin instead.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Hi mehmetcik,
Thanks for the response. I tried using Textjoin but it's giving me the same result.
=TEXTJOIN("-",,TEXT(Timecard!M12,"H:MM AM/PM"),TEXT(Timecard!M17,"H:MM AM/PM"))
Produces: 12:00 AM- 12:00 AM
Even though the cells M12 and M17 are blank
You'd need to use IF statements prior to converting cells to time text.
=TEXTJOIN("-",,IF(ISBLANK(Timecard!M12),"",TEXT(Timecard!M12,"H:MM AM/PM")),IF(ISBLANK(Timecard!M17),"",TEXT(Timecard!M17,"H:MM AM/PM")))
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
Thank you! Got it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks