Search : in
By :

Excel Text String Search/Return

Last answer on Jun 10, 2009 4:09:31 pm BST dhazen, on Jun 10, 2009 3:28:26 pm BST 
 Report this message to moderators

Hello,
I have a text string where I need to match one value and return data until a condition is met.
For example: - I have a column labeled 'TENSILE'

Text string: T=<46.72 KSI>/Y=<40.5 KSI>/E=<13%>

I need to return ONLY the 46.72 for the T value. I would repeat the steps for Y and E in other columns.
The kicker is that they are not always in the same order NOR are they the same length. I would return the value until either a space or a % sign appeared.

I would appreciate any suggestions as I have over 5000 lines of data to do this to.

Thanks!

Configuration: Windows XP Internet Explorer 7.0

Best answers for « Excel Text String Search/Return » in :
Deleting accents with PHP ShowDeleting accents with PHP For one reason or more, it may be useful to convert PHP accentuated text to a text without accents. Below is a simple function of how to perform this setting : function strip-Accents($string){ return...
Mktime() - Timestamp yesterday, last month, etc.). ShowMktime() - Timestamp yesterday, last month, etc.) Intro Last 24 hours Yesterday This week Last week This Month Last 30 days (last 30 days) Last month Current year(this year) Last year (last year) Intro The mktime()function...
[Excel 2003] - IF Function using Dates &amp; Text Show[Excel 2003] - IF Function using Dates & Text Issue Solution Note Issue I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell will read U16, but...
Download Unit Converter for Excel ShowIt is not always necessary to use an expensive or sophisticated program or to convert measurement units. It is sometimes enough to use Excel worksheet by only adding a plug-in. Unit Converter for Excel is one of Microsoft Excel plug-in which can...
Download ADO Export Show
Structure tags ShowTags can be divided into two groups: Those which change the structure of the page, and those which change the text style. Structure tags include header tags, paragraph tags, list tags, and more. Attributes The following attributes are placed within...
Ask your question Reply

1

flomaga, on Jun 10, 2009 3:47:47 pm BST
  • +3

All you need to do is change the allignment of the text in your cells so it fits correctly. Also you can just adjust the cell width to your taste

   
Reply to flomaga

2

 dhazen, on Jun 10, 2009 4:09:31 pm BST
  • +1

I apologize if I wasn't clear. The same length or location is for the value that I am looking for, not the actual cell length or location. Maybe a better example is to pull the "Y" value from the text string.
Thanks anyway!

   
Reply to dhazen
Ask your question Reply
They need your help