How can I get rid of a value next to a number?

[goldenheart]

Hi all,

I have an imported excel file, which has over 300 rows. I have 2 columns with numbers and I want to add the numbers in each row in the third column. However, all the numbers in the second column have all stars(*) next to them after 2 spaces. And, the digit of numbers change from 2 digit to 5 digit. How can I get rid of all the stars from 300 rows so that I can add them with the first column?

I would appreicate your help. Thank you,

[sweep]

Hi,

You can remove the * with the substitute function, and then turn the text back into a number with the value function, like so.

=VALUE(SUBSTITUTE(A1,"*",""))

[goldenheart]

Hi Dave,

Thanks a lot for your help. It did work. Thanks again.

Serhan