Spaced string value

cagataybaser

New Member
Joined
Jul 28, 2014
Messages
34
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
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

cagataybaser

New Member
Joined
Jul 28, 2014
Messages
34
oldbrewer thank you for reply,My cell value is :
3-Door
Convertible
And I cant use Case "3-Door Convertible"
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,307
Office Version
  1. 2010
Platform
  1. Windows
If I understand what you want correctly, do not use D12 in your formula, use this instead...

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

Watch MrExcel Video

Forum statistics

Threads
1,108,626
Messages
5,523,982
Members
409,550
Latest member
baaabies

This Week's Hot Topics

Top