VBA Function to do the job of TEXTJOIN gives extra commas

		Microsoft Office Forums > Microsoft Excel > Excel Programming
VBA Function to do the job of TEXTJOIN gives extra commas

FAQ

Thread Tools

Display Modes

12-20-2024, 05:35 PM

Chris G

Windows 11 VBA Function to do the job of TEXTJOIN gives extra commas

Office 2016

Novice

Join Date: Oct 2023

Posts: 9

Thanks p45cal, that is the solution. There is indeed a formula in each of the cells being concatenated, e.g. =IF(O20<>0,O20&" hrs " &TEXT(B20,"d-mm-yy"),""), so they look empty when there's no data to display.

So thank you very much indeed for the solution!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to identify and fix long sentences without commas	Bunnelope	Word VBA	12	03-29-2023 01:33 PM
Lookup and Textjoin help	ganesang	Excel	19	09-02-2021 12:48 AM
deleting blanks and commas	FUGMAN	Excel Programming	49	03-20-2017 10:17 AM
Commas within fields in .csv files	gar	Excel	1	01-29-2015 09:24 PM
No inverted commas in word 2013.	tonycrossley	Word	3	01-27-2014 04:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:51 AM.