Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 stackoverflow.com Dec 7 '12 at 9:45

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

1  
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. –  TheCellarRoom Dec 7 '12 at 8:48
1  
Press F1, type "text functions" and read up. –  Jean-François Corbett Dec 7 '12 at 9:45
add comment

1 Answer

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
add comment

Your Answer

 
discard

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