Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an excel document.

In a cell I have for example this value :

CRAZY DOG(1) [FOUR-F33202] 44123

I need to get (to put it in other cell) : CRAZY DOG

And I need to get too, in other cell : 44123

Is possible to do it with native functions of Excel ?

share|improve this question

migrated from Dec 7 '12 at 9:45

This question came from our site for professional and enthusiast programmers.

Probably Yes. But you need to provide the rules for the parsing pattern, and with more examples. – brettdj Dec 7 '12 at 8:31
You can use MID function to find last 5 digits (if it's always 5? you could also use the text-to-columns option breaking on ( the first time and ] the second time, delete the bits you don't need. – ChelseaStats Dec 7 '12 at 8:48
Press F1, type "text functions" and read up. – Jean-François Corbett Dec 7 '12 at 9:45

As you tagged only Excel below is an Excel solution.

Cell A1: CRAZY DOG(1) [FOUR-F33202] 44123

Returns "CRAZY DOG":

=LEFT(A1,FIND("(",A1) - 1)

Returns "44123":

=RIGHT(A1,LEN(A1)-FIND("]",A1) - 1)
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.