Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

113 points

How to extract characters or digits from cell content

Hi,

I'm trying to find out how I can grab a part of a cell content. Example: The cell has the content "1.22.333".

Now, I need to just grab the last part of that (and sometimes also the middle part). I tried to use the FIND and RIGHT function but the problem is that they need the amount of digits which can be different (1.2.3 or 1.22.333).

How can I grab/calculate just the "1" or "22" or "333" from that?

MacBook, OS X Mountain Lion (10.8), 2 GHz Core 2 Duo 1TB + 256 GB SSD

Posted on Mar 12, 2013 6:53 AM

Best reply

Badunit

Level 7

26,020 points

Posted on Mar 12, 2013 9:10 AM

There is more than one way to get what you want. Here is one:

Your 111.222.333 numbers are in column A

You will use four columns (B-E) to separate them.

B =LEFT(A,FIND(".",A)-1)

C =RIGHT(A,LEN(A)-FIND(".",A))

D =LEFT(C,FIND(".",C)-1)

E =RIGHT(C,LEN(C)-FIND(".",C))

B is the 1's

D is the 2's

E is the 3's

Hide column C

View in context

16 replies

gestyle

Level 1

1 points

Dec 8, 2013 5:05 AM in response to SGIII

Hey SGIII,

thank you for your message!

Both of your solutions work!

Also here I faced the same syntax issue as described in my previous answer to Badunit. I think it’s worth to show what happens, in case someone faces the same problem (NUMBERS says an argument is missing but in fact, it simply did not recognized “B3” because of the comma-thing) :

Next step: replacing comma by semicolon in both espressions solved the problem:

Perfect! 🙂

How to extract characters or digits from cell content