Removing "," at end.

[sksanjeev786]

Hi Team,

I don't want "," at the end for every table can anyone help me on this as I need at the end should be (157) with out ","

FS1.xlsx
	E	F	G	H
14	HP Awareness	Intel Consideration Unleash	Intel Consideration Multitask	HP Powerful as You - OOH
15	172	169	170	157
16
17	HP Awareness (172),	Intel Consideration Unleash (169),	Intel Consideration Multitask (170),	HP Powerful as You - OOH (157),
Sheet1

Cell Formulas
Range	Formula
E17:H17	E17	=E14&" ("&E15&"),"

Thanks
Sanjeev

 

[mohadin]

What about

=E14&"("&E15&")"

 

[sksanjeev786]

What about

=E14&"("&E15&")"

Hi Mohadin

I have applied your formula and I am getting below output in which all 3 digit getting delete as I need to remove only "," at the end only

HP Awareness(17)​

Intel Consideration Unleash (16)​

Intel Consideration Multitask(17)​

HP Powerful as You - OOH (15)​

 

[sandy666]

	E	F	G	H
14	HP Awareness	Intel Consideration Unleash	Intel Consideration Multitask	HP Powerful as You - OOH
15	172	169	170	157
16
17	HP Awareness (172)	Intel Consideration Unleash (169)	Intel Consideration Multitask (170)	HP Powerful as You - OOH (157)
Sheet4

Cell Formulas
Range	Formula
E17:H17	E17	=E14&" ("&E15&")"

 

[sksanjeev786]

	E	F	G	H
14	HP Awareness	Intel Consideration Unleash	Intel Consideration Multitask	HP Powerful as You - OOH
15	172	169	170	157
16
17	HP Awareness (172)	Intel Consideration Unleash (169)	Intel Consideration Multitask (170)	HP Powerful as You - OOH (157)
Sheet4

Cell Formulas
Range	Formula
E17:H17	E17	=E14&" ("&E15&")"

Hey Sandy,

Hope you are doing will I want to remove "," only at the end of the table not in entire table I want to remove in only H column which means every end fo the table

Thanks in advance
Sanjeev

 

[sandy666]

	E	F	G	H
14	HP Awareness	Intel Consideration Unleash	Intel Consideration Multitask	HP Powerful as You - OOH
15	172	169	170	157
16
17	HP Awareness (172),	Intel Consideration Unleash (169),	Intel Consideration Multitask (170),	HP Powerful as You - OOH (157)
Sheet5

Cell Formulas
Range	Formula
E17:H17	E17	=IF(COLUMN(E17)=COLUMN($H17),E14&" ("&E15&")",E14&" ("&E15&"),")

 

[Fluff]

Another option

+Fluff v2.xlsm
	E	F	G	H
14	HP Awareness	Intel Consideration Unleash	Intel Consideration Multitask	HP Powerful as You - OOH
15	172	169	170	157
16
17	HP Awareness (172),	Intel Consideration Unleash (169),	Intel Consideration Multitask (170),	HP Powerful as You - OOH (157)
Main

Cell Formulas
Range	Formula
E17:H17	E17	=E14&" ("&E15&")"&IF(F14<>"",",","")

 

[sksanjeev786]

	E	F	G	H
14	HP Awareness	Intel Consideration Unleash	Intel Consideration Multitask	HP Powerful as You - OOH
15	172	169	170	157
16
17	HP Awareness (172),	Intel Consideration Unleash (169),	Intel Consideration Multitask (170),	HP Powerful as You - OOH (157)
Sheet5

Cell Formulas
Range	Formula
E17:H17	E17	=IF(COLUMN(E17)=COLUMN($H17),E14&" ("&E15&")",E14&" ("&E15&"),")

Hey Sandy it work perfectly.

 

[sandy666]

You are welcome

 

[sksanjeev786]

Another option

+Fluff v2.xlsm
	E	F	G	H
14	HP Awareness	Intel Consideration Unleash	Intel Consideration Multitask	HP Powerful as You - OOH
15	172	169	170	157
16
17	HP Awareness (172),	Intel Consideration Unleash (169),	Intel Consideration Multitask (170),	HP Powerful as You - OOH (157)
Main

Cell Formulas
Range	Formula
E17:H17	E17	=E14&" ("&E15&")"&IF(F14<>"",",","")

Super Fluff.

Thank you so much