Display one number in a cell even though 2 numbers get pasted into the same cell?

[DrSues02]

I am trying to figure out how to format a cell so that it only display
the first number, even though two numbers are posted in the cell.

The reason that two numbers are posted in the cell is that I am copyin
the data from a website and when I post it into excel, it is using HTM
format to paste...

For example, if I post a column, it will have numbers set up lik
this:

+3 -109
-3 -103
+11 -110
-10 -105

The +3 -109 would all be in the same cell. I need each one of thos
cells to just display +3, then -3, then +11, then -10 after I past
them into the worksheet.

I want to take just the first numbers in the column and display onl
them so that I can use them in additional calculations on a differen
worksheet.

How would you go about doing this?

Thank you,

DrSues0

 

[Frank Kabel]

Hi
not really possible with formats. i would split the data in two
columns. e.g. use 'Data - Text to Columns' for this

 

[AlfD]

Hi!

...and even if there were such a way (which I am most earnestly sur
there isn't) it would still be a bad idea. First you try to format i
to see what you want: then you try to extract values to calculate wha
you want. It is a can of worms you are describing.

Frank is right.

Al