Spaces in pivot table

[louisehanna1990]

Hi there,

I was hoping someone could help me please.

The image is a pivot table that pulls percentages from a website. However, there is always a gap between the number the % symbol. Is there anyway that I can have the spaces removed?

Grateful for any support and help.

 

[gelu]

Hi L,

You could just TRIMM the imported dat and use the trimmed ones as the source of the pivot

Book1
	A	B	C	D	E	F
1
2
3		Imported	Trimmed			Pivot
4
5		Months	Months			Row Labels
6		Month Aug 17 %	Month Aug 17 %			Month Aug 17 %
7		Aug. 22 %	Aug. 22 %			Aug. 22 %
8		Sep 134. %	Sep 134. %			Sep 134. %
9						Grand Total
10
11
12
Sheet1

Cell Formulas
Range	Formula
C6:C8	C6	=TRIM(B6)

 

[louisehanna1990]

Thank you so much!!!!