# Close gap in numbers, sum and total

#### Clemo1

##### New Member
Hi Guys,

I have a spreadsheet that i have copied from an email which includes prices for certain equipment. I would like to remove the gap between the £ sign and value to neaten up but also due to me copying into excel it will not let me sum total or add any further formulas to turn it into a working sheet (yellow columns). I have had a read up and think that due to copying from an email it may be that it is all in text, hence causing issues with formulas etc.

Thank you.

#### sandy666

##### Banned - Rules violations
or if whole table is copied from email, use Power Query to get proper values in each column

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### Clemo1

##### New Member
or if whole table is copied from email, use Power Query to get proper values in each column
Thanks Sandy 666 for all the help. The power Query looks the way to go. Great advice.

#### sandy666

##### Banned - Rules violations
You are welcome
 Code Description Number Weight Sale Hire 285001 4.0M METRIX STAN DARD 1 18.84 £38.83 £0.21 285005 3.0M METRIX STAN DARD 1 14.37 £30.23 £0.16 285010 2.5M METRIX STAN DARD 1 12.13 £27.85 £0.15 285015 2.0M METRIX STAN DARD 1 9.9 £20.45 £0.11 285020 1.5M METRIX STAN DARD 1 7.55 £17.78 £0.09 285025 1.0M METRIX STAN DARD 1 5.43 £12.45 £0.07 285030 0.5M METRIX STAN DARD 1 3.19 £9.79 £0.05 285035 4.0M METRIX STANDARD BOLTED SPIGOT 1 19.9 £45.05 £0.26 285040 3.0M METRIX STANDARD BOLTED SPIGOT 1 15.42 £35.45 £0.19 285045 2.5M METRIX STANDARD BOLTED SPIGOT 1 13.19 £34.09 £0.18 285050 2.0M METRIX STANDARD BOLTED SPIGOT 1 10.95 £25.62 £0.14 285055 1.5M METRIX STANDARD BOLTED SPIGOT 1 8.72 £24.01 £0.13

all the yellow columns you can calculate in Power Query also

Replies
7
Views
81
Replies
2
Views
80
Replies
4
Views
86
Replies
9
Views
320
Replies
5
Views
193

1,127,530
Messages
5,625,361
Members
416,096
Latest member
forevans

### 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