Hi folks, I was wondering if one of all you smart people could help me find a formula...
This is what I am trying to do:
I have a cell with the following information in it:
2/1 Andromeda_slot4 connected 580 normal full 1000 1000BaseSX
I would like to get the word "connected" out of the cell and in to a cell of its own?
But it is not that simple, because I know you can search the cell for the word "connected" and it will return the start position and from there I know you can get the entire word using "=mid(A1,'start_num','num,char')" and job done...
However the word isn’t always "connected" and isn't always in the same start position, and here lies the problem.
Is there a command that tells me the start position of the word "connected" or the word "disabled" or the word "notconnected"?
I would really appreciate any assistance with this
Many Thanks
CoolSnaz
This is what I am trying to do:
I have a cell with the following information in it:
2/1 Andromeda_slot4 connected 580 normal full 1000 1000BaseSX
I would like to get the word "connected" out of the cell and in to a cell of its own?
But it is not that simple, because I know you can search the cell for the word "connected" and it will return the start position and from there I know you can get the entire word using "=mid(A1,'start_num','num,char')" and job done...
However the word isn’t always "connected" and isn't always in the same start position, and here lies the problem.
Is there a command that tells me the start position of the word "connected" or the word "disabled" or the word "notconnected"?
I would really appreciate any assistance with this
Many Thanks
CoolSnaz