Question: I have a row of numbers that I need to sum. When I try to sum I get zero (0) when I know there should be a value. The numbers all have a (-) negative sign at the end and an extra space at the end.

How do I convert this to an actual number, remove the extra space to be able to sum up? Do I need to remove the (-) negative sign at the end and move to the front?

Here's the data I'm working with.

[![enter image description here](https://i.stack.imgur.com/hKxqC.jpg)](https://i.stack.imgur.com/hKxqC.jpg)

Answer: 
Select the relevant Column, Text to Columns, Delimited by 'space', check Trailing minus for negative numbers.
Try the following formula which will remove the `-` sign and any unwanted spaces. It will then convert it to a value so you can `SUM()`.

```
=CLEAN(TRIM(LEFT(D6,LEN(D6)-1)))

```

Change the range as needed.