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

D

DrSues02

Ok. Maybe I didn't explain myself thoroughly.

I don't care about the second number. I just want to get rid of th
second number in the cell and only keep the first.

Can I do this by using Data - Seperate Text into columns? If so, ho
do I do this?

Any other possible suggestions?

DrSues0
 
D

Dave Peterson

Yep.

Select that column of cells.
data|text to columns
delimited by space
do not import the second column
 
Top