LinkBack URL
About LinkBacks
=LEFT(B52,(FIND("VOL",B52,1)-1))
This is my formula, i need to add additional words to VOL and need to work down the spreadsheet adding extra words.
How can this be done.
=LEFT(B52,(FIND("VOL",B52,1)-1))
This is my formula, i need to add additional words to VOL and need to work down the spreadsheet adding extra words.
How can this be done.
Write in some range all words you need to find.
For example from L1 to L100
Then use this:
Formula:
Please Login or Register to view this content.
comfirmed with ctrl+shift+enter not just enter
Hint: SEARCH is not case sensitive
Never use Merged Cells in Excel
Hi,
Please attach a sample workbook explaining exact inputs and the expected output.
Regards,
Paresh J
Click on "* Add Reputation" as a way to say thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks