Rank: Member
Joined: 5/4/2010 Posts: 21 Location: D
|
Hi, I need to concat some cells per row from an Excel sheet into a string. If all cells have a value, it works fine. If one the cells has no value, I get no output. How can I check, if a cell is empty, that I can insert an empty string as concat part?
Thanks in advance
Heiko
|
Rank: Advanced Member
Joined: 12/13/2005 Posts: 2,856 Location: Mauritius
|
substitute-missing function (not sure whether it was available in MF2009 though)
|