nehachoubey
Board Regular
- Joined
- Aug 17, 2011
- Messages
- 52
Hi i have a string like this ('hello'). How can i get the string inside the quotes ie hello?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
get the string within (' ')
- Thread starter nehachoubey
- Start date
Rick Rothstein
MrExcel MVP
- Joined
- Apr 18, 2011
- Messages
- 38,522
- Office Version
- 365
- Platform
- Windows
Give this formula a try...
=MID(A1,FIND("'",A1)+1,FIND("'",A1,FIND("'",A1)+1)-FIND("'",A1)-1)
=MID(A1,FIND("'",A1)+1,FIND("'",A1,FIND("'",A1)+1)-FIND("'",A1)-1)
Upvote
0
