LinkBack URL
About LinkBacks
Extract words/numeric after each specific word
please find attached
Extract words/numeric after each specific word
please find attached
Hi chweetvjy, may be:
1. replace "#~#" with some character (e.g. "@") that you're not using in the data range
2. use [Text to Columns] and delimit it by "@"
_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved
Alvin
A simple UDF would make it easy and tidy:
The use the following in range B2:I3
Please Login or Register to view this content.
Formula:
Please Login or Register to view this content.
Last edited by Olly; 01-22-2014 at 06:43 AM.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks