Forum Discussion
Concantenate and Ignore 0s
I am making a template. Sheet 2 is the input sheet for data, Sheet 1 moves that data from Sheet 2 into Sheet 1 and adds a column with a concatenate formula since we need a column with a Unique ID. Sh...
What are the formulas you currently use?
HansVogelaar just concantenate so =G2&O2 for example which returns 00 if the cells are blank. I can do it with a JOIN TEXT formula but it requires I add a space. Would like to avoid that if I can as it means needing to go in and modify my current data already in the system.
