Pull numbers from a cell

G

Guest

If I have a call with 3 sets of numbers in it. EG (11 2 8) or (1 12 16)
How can I refer to just the first number or just the second or just the third?
I can't count the characters because some may be single digit and some may
be double digit.
Or if I can split it out into the three numbers that would work.
 
N

N Harkawat

easiest would be to split these numbers into 3 separate cells using
data-->text to columns-->
delimited
Next
check on the space
and hit Finish,
 
G

Guest

Let me narrow that down a little more. If I hace 2 cells that equal each
other...
(11 2 8)
(11 2 8)
I want to combine them in a new cell by adding together only the second
number. so it would say...
(11 4 8)
????
 

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

Top