Hi there...
I am looking for some helping extracting the number of clicks to the left of the word "clicks" within the cell.
In addition, I was hoping to extract the characters to the right of the # sign.
Third, I was hoping to delete the word clicks and the numbers to the left of the word "clicks" in the post title column. At the leExcel Doc.xlsxExcel Doc.xlsxast, if I could get help accomplishing the first item above, that would be a huge help. Thanks!
Bansi
Its good you uploaded a sample, the only problem is, there are no examples of what you expect to see???, you expalnation is very confusing, to me at least
Not exactly sure what you mean here??I am looking for some helping extracting the number of clicks to the left of the word "clicks" within the cell.
Several # signs in many of the data, which # sign..the first 1, the last 1, the first 1after the word "clicks"...?In addition, I was hoping to extract the characters to the right of the # sign.
A couple examples of what you would like to see would be most helpful
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
=IFERROR(MID(A2,FIND("clicks",A2)+LEN("clicks "),LEN(A2)),"")
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks