|The brute force method is this:|
If you need to keep the data in the cells intact, you could put this in B1 and then drag it down:
That will give you a list of numbers that you could Sum.
If it's OK to split the cells, select Column A and perform Data...Text-to-Columns...Delimited by a space.
That will create a column of numbers and a column of text.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.