happy_smiler1
New member
- Joined
- Aug 28, 2012
- Messages
- 67
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- office 365
Hi All,
Kind of stuck with trying to find a word within a text cell. I have attached a workbook with some examples. In column "I", I need to find the city from the text field in column H, however it is the text in the middle so for example Ipswich, Suffolk I would need it to pull out Ipswich only. I have tried mid/len/substitute, however none of these give me what I need, if anyone could help.
Would really be appreciated.
Kind of stuck with trying to find a word within a text cell. I have attached a workbook with some examples. In column "I", I need to find the city from the text field in column H, however it is the text in the middle so for example Ipswich, Suffolk I would need it to pull out Ipswich only. I have tried mid/len/substitute, however none of these give me what I need, if anyone could help.
Would really be appreciated.