combine formulas or make it into a macro

[jmkerzic]

I have the following 3 formulas. Is it possible to combine them into one or write a macro for them.

=IF(LEFT(C:C)="R",G:G&" Rack")
=IF(AND(LEFT(C:C)="R",RIGHT(C:C)="B"),G:G&" BLM Rack")
=IF(RIGHT(C:C)="B",G:G&" BLM",IF(RIGHT(C:C,1)="C",G:G&" BLM",IF(LEFT(C:C,3)="TRT",G:G&" TRT",G:G)))

 

[Eric W]

Maybe:

Book1
	C	D	E	F	G	H
2	xxx				a	a
3	rx				b	b Rack
4	rb				c	c BLM Rack
5	xb				d	d BLM
6	xxxc				e	e BLM
7	trt123				f	f TRT
8	yyy				g	g
Sheet5

Cell Formulas
Range	Formula
H2	=G2&IF(OR(RIGHT(C2)={"B","C"})," BLM","")&IF(LEFT(C2)="R"," Rack","")&IF(LEFT(C2,3)="TRT"," TRT","")

 

[jmkerzic]

It worked. Thanks.

 

[Eric W]

You're welcome.