Is it possible to Concatenate Symbols and Text in Single Cell

[andyka]

Is it possible Concatenate CHAR symbols "Webdings" and text from two different Cells. I am using "Webdings" in cell C10 and text in D10. I want Results in D2

KPI example.xlsx
	B	C	D
2
3			Overall
4			Amber
5		5	Stable
6		6	Critical
7		34	Warning
8
9
10		34	Warning
11
12
13
14
Sheet1

Cell Formulas
Range	Formula
C10	C10	=IF(D4="Green",CHAR(53),IF(D4="Red",CHAR(54),IF(D4="Amber",CHAR(51)&CHAR(52),"")))
D10	D10	=IF(C10=CHAR(53),"Stable",IF(C10=CHAR(54),"Critical",IF(C10=CHAR(51)&CHAR(52),"Warning","")))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D10	Cell Value	="Critical"	text	NO
D10	Cell Value	="Stable"	text	NO
D10	Cell Value	="Warning"	text	NO
C10	Cell Value	=CHAR(54)	text	NO
C10	Cell Value	=CHAR(51)&CHAR(52)	text	NO
C10	Cell Value	=CHAR(53)	text	NO
D9	Expression	=IF(D4="Green",CHAR(5)&" Stable",IF(D4="Amber",CHAR(6)&" Critical",IF(D4="Red",CHAR(34)&" Warning","")))	text	NO

 

[kevin9999]

Deleted - unfortunately, even downloading the file shared to Google Drive doesn't display the icon set

 

[FormR]

Hi, instead of using webdings, you could use a normal font and embed the equivalent unicode characters that are represented by the webdings font directly into your formula - you can then easily concatenate these without issue - for example:

Book3
	A	B	C	D
1
2				Stable⯇⯈
3				Overall
4				amber
5			5	Stable
6			6	Critical
7			34	Warning
8
9
10			⯇⯈	Stable
Sheet1

Cell Formulas
Range	Formula
D2	D2	=D10&C10
C10	C10	=IF(D4="Green","⯅",IF(D4="Red","⯅",IF(D4="Amber","⯇⯈","")))
D10	D10	=IF(C10="⯅","Stable",IF(C10="⯆","Critical",IF(C10="⯇⯈","Warning","")))

 

[andyka]

Hi, instead of using webdings, you could use a normal font and embed the equivalent unicode characters that are represented by the webdings font directly into your formula - you can then easily concatenate these without issue - for example:

Book3
	A	B	C	D
1
2				Stable⯇⯈
3				Overall
4				amber
5			5	Stable
6			6	Critical
7			34	Warning
8
9
10			⯇⯈	Stable
Sheet1

Cell Formulas
Range	Formula
D2	D2	=D10&C10
C10	C10	=IF(D4="Green","⯅",IF(D4="Red","⯅",IF(D4="Amber","⯇⯈","")))
D10	D10	=IF(C10="⯅","Stable",IF(C10="⯆","Critical",IF(C10="⯇⯈","Warning","")))

Thank you so much for your help! You're a Star