extracting number from cell contains both text and number alternatively

hi
Friends

can any one solve the problem for me iam having text and number as follows "1.20hc(0.283hc)" i want to extract the number with in the braces that is 0.283 like any length of number in to another cell

how to solve this please help me

thanking u
green

Hi

Can you post a sample worksheet so we can see the layout etc dont post confidental information
it will also get you a much better response and are all cells the same length of characters or does it vary.


To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.



Chris

try this

Please Login or Register  to view this content.

double post

Is the text following the number always the same?

How about posting several samples so we can see if there's a pattern we can exploit.