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

  • Thread starter Thread starter DrSues02
  • Start date Start date
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
 
Yep.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display one number in a cell even though 2 numbers get pasted into the same cell? 2
showing 2 numbers in a cell 2
Drop down / validation / lookup into the same cell 2
Paste cells copied from another sheet 2
pasting with filter results into sequentual cells not same row? 1
dividing a number into hours and minutes 1
Summing Numbers and Text in same cell 3
macro that will paste a number in first blank cell of a column 1

Back
Top