getting text and numbers into Pivot table

[chrisng1]

I have a cell in my table that have number and text for example CB $14.95.. are there any way that I can get this number and text into the Pivot table? any help is deeply appreciate..

 

[NeonRedSharpie]

I don't know what you mean...but you'll have to split it somehow. This can either be done with a helper column or you can do a calculated field to split them (I believe)

Left of space

=LEFT(H11,FIND(" ",H11)-1)

Right of space

=RIGHT(H11,LEN(H11) - FIND(" ",H11))

 

[chrisng1]

I don't know what you mean...but you'll have to split it somehow. This can either be done with a helper column or you can do a calculated field to split them (I believe)

Left of space

=LEFT(H11,FIND(" ",H11)-1)

Right of space

=RIGHT(H11,LEN(H11) - FIND(" ",H11))

I was hoping to find a way to get the cell that contained text and the number into the Pivot table the cell have txt which is CB, and the number which is 14.5.. I want the table values to be able to stated
CB 14.5

 

[NeonRedSharpie]

I was hoping to find a way to get the cell that contained text and the number into the Pivot table the cell have txt which is CB, and the number which is 14.5.. I want the table values to be able to stated
CB 14.5

I think you're going to need a helper column that splits it before the pivot table. I just tried using calculated fields and they won't return expected results.