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 am trying to parse out the individual dimensions (length, height, width) for a string in Excel but am having problems determining which text formulas to use. Details below.

Data example (in one cell): 1 5/8 x 8 x 5/8

Desired Output (in individual cells): Cell 1: '1 5/8' Cell 2: '8' Cell 3: '5/8'

share|improve this question
1  
I direct you to this answer Microsoft Excel Macro. You can easily adapt that solution to your specific problem. –  Doktoro Reichard Aug 30 '13 at 19:03

2 Answers 2

up vote 1 down vote accepted

You can trim out portions of the string, based on finding the "x" in your string. Will this be for only one cell or many?

To get things started with how the trimming could be accomplished: assuming the string is in cell A1, and you want the first part of the dimension in B1, you could put this formula in B1:
=LEFT(A1,LEN(A1)-(FIND("x",A1,1)+2))

The LEFT function returns the left portion of a string. LEN returns the length, and FIND searches for one string within another.

share|improve this answer
1  
This is what I ended up doing, using the find() function to locate the two 'x' values and parsed out the first, second and third portions of the string in conjunction with the left() and right() functions –  Gryphoenix Aug 30 '13 at 19:14
    
Aaron, since this was marked as accepted, could you please expand your answer to include a little more explanation (what Gryphoenix said), and not end it in a question? Otherwise this would have been more suitable as a comment. Thanks. –  slhck Aug 30 '13 at 19:38
    
Sure, I will edit the answer to include an example. –  Aaron Thomas Aug 30 '13 at 19:45

This answer and this answer give examples of how to use Excel’s capabilities to do this sort of thing.

share|improve this answer

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.