i am importing data from a text file. I know how to do it if the text file is organized properly so columns and rows are easily imported. However this text file doesn't fall under that category, so i am looking for a way to match the first part of the cell and return the last part. For example: lets say Cell A1 has words "Input Any" these words should be in separate cells. so i want to (hopefully with a formula) look up the word "input" and then return the word "Any".
However this text file doesn't fall under that category,
In what way? What does the file look like?
Need more info and examplesIf the text string is ALWAYS going to be the word "Input"
and the return string is always going to be "Any"
then this should work:=IF(LEFT(A1,5)="Input",RIGHT(A1,3),"")
But I know it is going to be more complicated than that.