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..
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)
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)
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 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.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.