text string

I have an excel spread sheet that has a column with lists in text format separated by comma. Each individual field has different amounts of word. what I have word1,word2,word3,word4 what I want word4,word3,word2,word1 Some fields may have 4 words, other may have 6, other 10, etc. Is...

I have a lot of data (circa 6,000 rows!) to clean. In the date/time cells the entries appear as a text string like this: 2011-01-30T00:33:54.67 I need to separate it into two separate entries – one for the date and one for the time. So for example <TABLE style="BORDER-BOTTOM: medium none...

68049806AA CAP&MOUNT RING ASSY BATTERY That is an example of many rows of data. I need to remove the first 10 characters and leave only the Text. Any ideas.....

Is there a formula to remove everything after a certain character for variable text strings? for example: Turnthis... Single basin|,Double basin|,Triple basin| Double handle|,Single handle|,Touchless| Single hole|,Two holes|,Three holes|,Four holes|,Single hole with deck plate| into this...

Hi All, I am trying to create a formula that counts the number of times a specific text string appears in a column. Within the column, the text string may appear within a larger text string within a cell. For example, Column D has 15000 rows with various text messages. I need to count...

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List"...

I am trying to write a UDF to remove certain words from an imported text string. For example, an imported text string might be air-conditioning systems or aircon system I want to be able to remove the "-" "systems" and "system". I also want to easily add other words to exclusion list in due...

Can anyone help... I am looking to define the sum of a set of values that correspond to a specific text string in another column. For instance, in rows A1:A6, if the term "Hello" is used, I would like to see the sum of the corresponding values in rows B1:B6. If a different word in A1:A6 is...

Hello. I'm trying to set up a conditional format so my cells will be filled if the value includes a specific text string, but I need to use wildcards before and after the specific text string. In other words, if the cell value contains the text "my specific text", anywhere in the cell value, I...

I have a 10 step process for creating classes. As each step is completed, an "X" is placed in the spreadsheet cell. If 5 steps are complete, I would like to have the chart display that 50% of the process is complete. How do I assign a 10% value to the "X" in the cell in the spreadsheet so...

Having now worked, unsuccessfully, for the last 4 hours on a formula, I am wondering whether anyone can now help. In cell A1 we need to check for the word "DECK" as the 1st four characters, if this is TRUE then we MAY need to amend it in cell A4. If it says DECK 1, DECK 2, DECK 3 and so on to...

This is my first post so i do appologise if this question has already been answered - but i am well and truly stuck. A B C <TABLE style="WIDTH: 348pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=464 border=0><COLGROUP><COL style="WIDTH: 200pt; mso-width-source: userset...

In Excel 2003, I am referencing a text string and would like to return the text string with only the first letter capitalized. The PROPER function does not do this, as it capitalizes the first letter of every word. The formula below does however perform this, but I would like to write it as a...