View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

If they are empty, then there's nothing to concatenate
and thus nothing to worry about. To concatenate a range
of cells, try a UDF like this one from J.E. McGimpsey:

http://tinyurl.com/5wvz3

HTH
Jason
Atlanta, GA

-----Original Message-----
I am trying to concatinate a row of 30 cells. Some of

these are empty or
blank. I want to combine these 30 cells where they are

not blank. I have
tried several functions, however the limit is 7

functions in one cell. How
can I complete this task?
.