I have a spreadsheet that I have created that is used to import a text file with text strings. The intention of the spreadsheet is to take bits of information from the text file and compose it into a more human readable format. For example, the above text string I would like to extract the tag description Under Voltage and put it into a table on a different sheet so I can see what the tag has been labelled as. My issue is that the wording Under Voltage is liable to change. It can be renamed in a different text file, and called "Voltage Under Range" for instance, so I want to be able to take the text inside the > < whatever that may be, and move it into a different cell. Is there a way to do this? I have used functions like mid, etc but they are reliant on the text remaining exactly as it is above which isn't likely if somebody renames the tag. I'm happy to achieve this via VBA or Formula.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Copying a specific part of a text string into a different cell
- Thread starter eDarren
- Start date
I have a spreadsheet that I have created that is used to import a text file with text strings. The intention of the spreadsheet is to take bits of information from the text file and compose it into a more human readable format. For example, the above text string I would like to extract the tag description Under Voltage and put it into a table on a different sheet so I can see what the tag has been labelled as. My issue is that the wording Under Voltage is liable to change. It can be renamed in a different text file, and called "Voltage Under Range" for instance, so I want to be able to take the text inside the > < whatever that may be, and move it into a different cell. Is there a way to do this? I have used functions like mid, etc but they are reliant on the text remaining exactly as it is above which isn't likely if somebody renames the tag. I'm happy to achieve this via VBA or Formula.
Excel Facts
Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Similar threads
