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

Top-ranking reply

Badunit

Level 7

30,726 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

Badunit

Level 7

30,726 points

Dec 7, 2013 7:04 PM in response to gestyle

Using Barry's formula with some slight editing:

=MID(B3,FIND("-",B3)+1,FIND("-",B3,(FIND("-",B3)+1))−FIND("-",B3)−1)

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How to extract characters or digits from cell content