Solved How to look up first half of cell contents and return second

May 16, 2017 at 17:52:20
Specs: Windows 7
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".

See More: How to look up first half of cell contents and return second

Report •

#1
May 16, 2017 at 18:05:40
✔ Best Answer
However this text file doesn't fall under that category,
In what way? What does the file look like?
Need more info and examples

If 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.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question