LinkBack URL
About LinkBacks
In B1 =LEFT(A1,FIND("/",A1)-1)
In C1 =MID(A1,FIND("/",A1)+1,FIND("(",A1)-FIND("/",A1)-1)
In D1 =RIGHT(A1,LEN(A1)-FIND("(",A1)+1)
Assumes data is in A1
In B1 =LEFT(A1,FIND("/",A1)-1)
In C1 =MID(A1,FIND("/",A1)+1,FIND("(",A1)-FIND("/",A1)-1)
In D1 =RIGHT(A1,LEN(A1)-FIND("(",A1)+1)
Assumes data is in A1
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
these responses were top class and both work, thanks for your help.
regards,
burdo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks