troubleshooting Question

Remove Null values from Concatenate string

Avatar of Karen Schaefer
Karen SchaeferFlag for United States of America asked on
Microsoft ExcelMicrosoft Office
3 Comments1 Solution177 ViewsLast Modified:
Handling NuLL in a concatenated statement.

How do I remove any values containing "NULL".

I am trying to concatenate the Type and size into a single value, however, some of the size = "Null".

I want to remove the Null from the concatenated values.

TYPE       Size          Final value
varchar      8      NO      varchar(8)
varchar      10      NO      varchar(10)
datetime      NULL      NO      datetime(NULL)
varchar      40      YES      varchar(40)
varchar      50      YES      varchar(50)
varchar      25      YES      varchar(25)
varchar      25      YES      varchar(25)
varchar      17      YES      varchar(17)
varchar      50      YES      varchar(50)
varchar      40      YES      varchar(40)
varchar      40      YES      varchar(40)
varchar      10      YES      varchar(10)
varchar      36      YES      varchar(36)
varchar      36      YES      varchar(36)
datetime      NULL      YES      datetime(NULL)
datetime      NULL      YES      datetime(NULL)
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros