There is a file we pull from a system and it gives back the amounts in hyperlink form, however, I am trying to add those all up without having to remove or retype the hyperlinks amounts. I was wondering if anyone could help me out. Ive tried the "copy 1 paste special trick", it worked but would not let add them up and only counted. Have to do this each month, so trying to figure out an easier way to do this month-to-month.
Column A is what I what I would want the result to look like. Just simply entered into a1 =b1 and down to give example, but at the bottom it also shows how it would not add those up either. End result, one column with just the number with no links and able to add them up because I have to sort them out by accounts.
Thanks,
Ant
Bookmarks