Please someone help: Copy and paste from excel to web based program whithout spaces

RJBRITZ

New Member
Joined
Jan 8, 2014
Messages
4
I use Excel to calculate large amounts and totals because it works good.
We work on a relatively primitive web based program that require manual calculation of large amounts of items at different rates etc.
I use excel to do the calculations and then copy and paste it when completed into our primitive web based program.
The only problem I am encountering and hope to eliminate is the spacing.
I have to use several columns to enter different formulas in excel.
I leave no spaces between the text but when I paste into our web program it automatically creates spaces between my text which was in separate columns in the excel sheet.
Here is an example of what I want to be able to paste from my excel document without it creating extra spaces that I have to manually take out one by one in the web based program.
The transaction is analyzed as follows:
15 Ha Arable lands @ R 5 500/ha = R 82 500
156 Ha Nat grazing @ R 4 600/ha = R 717 600
Total land aspect: R 800 100
(Rand/ha) (R 4 679)
Improvements R 149 900
Total R 950 000
(Rand/ha) (R 5 555)

Someone please help.:(
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
I leave no spaces between the text but when I paste into our web program it automatically creates spaces between my text which was in separate columns in the excel sheet.

Is that the only problem, you get extra spaces BECAUSE OF the different Columns that the text is copied from. Do you need to put each word into its own cell, can you MERGE cells in your Excel worksheet(s)? Do you have one word per cell or multiple works per cell. With this idea, do you have a new possible solution at hand.

Can you type in the resulting format of your web based Transaction from above showing where the extra spaces are located and please explain where the column divides are located, thank you. SHOW EXTRA SPACES BELOW

The transaction is analyzed as follows:
15 Ha Arable lands @ R 5 500/ha = R 82 500
156 Ha Nat grazing @ R 4 600/ha = R 717 600
Total land aspect: R 800 100
(Rand/ha) (R 4 679)
Improvements R 149 900
Total R 950 000
(Rand/ha) (R 5 555)
 
Upvote 0

Forum statistics

Threads
1,215,334
Messages
6,124,319
Members
449,154
Latest member
pollardxlsm

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