Avatar of Karen Schaefer
Karen SchaeferFlag for United States of America

asked on 

Remove Null values from Concatenate string

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)
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Karen Schaefer

ASKER

=SUBSTITUTE(A2&"("&B2&")","(NULL)","")  Did the Trick.

Thanks,
You're welcome Karen! Glad it worked as desired.
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo