Spaced string value

[cagataybaser]

Hello in my D12 cell there is a value like that3-DoorConvertibleAnd When I tried to use it like this : Case "3-Door Convertible"it is not working..How I can do that?Kind regards

 

[oldbrewer]

are you trying to insert a space after Door?

 

[cagataybaser]

oldbrewer thank you for reply,My cell value is :
3-Door
Convertible
And I cant use Case "3-Door Convertible"

 

[Rick Rothstein]

If I understand what you want correctly, do not use D12 in your formula, use this instead...

SUBSTITUTE(D12,CHAR(10)," ")