02-19-2012, 02:52 PM
Here is one more logic
Code:
data ="I am in [London] for 1 week"
a=split(data,"[")
b=Trim(Split(a(1),"]"))
msgbox b(0) 'London