# getting text and numbers into Pivot table

#### chrisng1

##### New Member
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..

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

#### NeonRedSharpie

##### Well-known Member
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
Code:
``=LEFT(H11,FIND(" ",H11)-1)``

Right of space
Code:
``=RIGHT(H11,LEN(H11) - FIND(" ",H11))``

#### chrisng1

##### New Member
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
Code:
``=LEFT(H11,FIND(" ",H11)-1)``

Right of space
Code:
``=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

##### Well-known Member
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.

Replies
1
Views
331
Replies
2
Views
770
Replies
2
Views
2K
Replies
14
Views
5K
Replies
1
Views
541

1,195,858
Messages
6,011,983
Members
441,661
Latest member
Pammie007

### We've detected that you are using an adblocker.

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.

### Which adblocker are you using?

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

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.
Go back