I am in need of a way to extract data between the { } brackets. Data is Mixed case, mixed length, alphanumeric.
Thanks,
Brad
How to extract data between { }
-
- 4StarLounger
- Posts: 538
- Joined: 30 Mar 2010, 18:49
- Location: United States
-
- 4StarLounger
- Posts: 538
- Joined: 30 Mar 2010, 18:49
- Location: United States
Re: How to extract data between { }
Ha! Found it!!!
=MID(A2,FIND("{",A2)+1,FIND("}",A2)-FIND("{",A2)-1)
=MID(A2,FIND("{",A2)+1,FIND("}",A2)-FIND("{",A2)-1)
-
- Administrator
- Posts: 78475
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands