I receive csv files that need to have the column totaled. I have tried to write a formula to remove the text and characters with no luck. I don't know it there is a formula or should it be a macro. I have attached the file that I receive. I really appreciate all the help I get here.
1) text to column
use - as seperator
2) after that find / replace
CTRL + H
find '
replace by leave blanc
after that just a sum formula.
See the attached file for the result.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Can you explain your desired results?
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
I see that you have removed the text and all, but I don't understand how it was done. Can you provide the formula written out.
My desired results would be to get a total amount of the numbers in each cell.
Hi Roco,
Enter this formula in cell B2 and pull formula to the right (cell C2) and then down
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks