remove leading spaces from imported text file

  • Thread starter Thread starter smurf01
  • Start date Start date
S

smurf01

Hi, I have an excel sheet with times on it that has come from a tex
file, I cannot do sums on the time as the data containing leadin
spaces. If I delete these spaces manually then I can do SUMS. Doe
anyone know of a way to remove these spaces automaticall
 
smurf01 said:
Hi, I have an excel sheet with times on it that has come from a text
file, I cannot do sums on the time as the data containing leading
spaces. If I delete these spaces manually then I can do SUMS. Does
anyone know of a way to remove these spaces automatically
Click to expand...

It's not just a matter of removing spaces. You also have to convert text
strings (which is what you have) into values. I suggest you use a formula to
do this. For example, for a string in A1 you would use
=VALUE(A1)
You would then need to format the cell as time. Calculations will then be
possible.
 
Back
Top