Close gap in numbers, sum and total

Clemo1

New Member
Joined
Feb 23, 2012
Messages
40
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.
1602663994549.png


Thank you.
 
or if whole table is copied from email, use Power Query to get proper values in each column
 
Upvote 0

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
You are welcome
CodeDescriptionNumberWeightSaleHire
2850014.0M METRIX STAN DARD118.84£38.83£0.21
2850053.0M METRIX STAN DARD114.37£30.23£0.16
2850102.5M METRIX STAN DARD112.13£27.85£0.15
2850152.0M METRIX STAN DARD19.9£20.45£0.11
2850201.5M METRIX STAN DARD17.55£17.78£0.09
2850251.0M METRIX STAN DARD15.43£12.45£0.07
2850300.5M METRIX STAN DARD13.19£9.79£0.05
2850354.0M METRIX STANDARD BOLTED SPIGOT119.9£45.05£0.26
2850403.0M METRIX STANDARD BOLTED SPIGOT115.42£35.45£0.19
2850452.5M METRIX STANDARD BOLTED SPIGOT113.19£34.09£0.18
2850502.0M METRIX STANDARD BOLTED SPIGOT110.95£25.62£0.14
2850551.5M METRIX STANDARD BOLTED SPIGOT18.72£24.01£0.13

all the yellow columns you can calculate in Power Query also
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,186
Members
448,554
Latest member
Gleisner2

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