Hi,
I would like to get the area marked in red for each item. How can I get that?
[998][6/29/2010 00:11:54:143]-INFO-[ThreadId = 6348
[999][6/29/2010 00:11:54:143]-INFO-[ThreadId = 6348
[1000][6/29/2010 00:11:54:143]-INFO-[ThreadId = 6348
[1001][6/29/2010 00:11:54:143]-INFO-[ThreadId = 6348
Thanks!
If the strings are in A1:A4 then
B1: =REPLACE(LEFT(A1,FIND("-",A1&"-")-1),1,FIND("]",A1&"]"),"")
copied down to B4
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Try
=MID(A1,FIND("[",A1,2)+1,FIND("-",A1)-FIND("[",A1,2)-2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks