Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-24-2020, 02:13 AM
Marcia's Avatar
Marcia Marcia is offline Extract all characters from the nth number of a string Windows 7 32bit Extract all characters from the nth number of a string Office 2013
Expert
Extract all characters from the nth number of a string
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Extract all characters from the nth number of a string

Hi. The below formula in C2 is returning an error.
=B2-LEFT(B2,Search("f",B2))


I would want the formula to return all the data in B2 except all of the characters before the first occurrence of "of" from the left, "of" included. Like, "number of circles in the picture of the garden." The formula should return " circles in the picture of the garden."
Finally, I got it right by:
=RIGHT(B2,LEN(B2)-SEARCH("f",B2))
Sorry for the bother.
Thank you.
Reply With Quote
  #2  
Old 02-24-2020, 07:13 AM
jeffreybrown jeffreybrown is offline Extract all characters from the nth number of a string Windows 10 Extract all characters from the nth number of a string Office 2016
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Hi Marcia,

It's no problem to post if you are hitting a snag. Glad you found your solution, but here is another one you could try.

=MID(B2,SEARCH("of",B2)+2,LEN(B2))
Reply With Quote
  #3  
Old 02-24-2020, 05:15 PM
Marcia's Avatar
Marcia Marcia is offline Extract all characters from the nth number of a string Windows 7 32bit Extract all characters from the nth number of a string Office 2013
Expert
Extract all characters from the nth number of a string
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Thank you Jeffrey. I prefer your formula. It is confusing to use the RIGHT function.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract States from a String soldat452002 Excel 9 04-26-2018 04:16 AM
Extract all characters from the nth number of a string Extract a string from a paragraph kirkm Word VBA 7 09-11-2016 06:13 PM
How to extract only numbers from a STRING? Learner7 Excel 3 07-02-2013 06:25 AM
Extract all characters from the nth number of a string Extract Numbers from Alphanumeric String OTPM Excel 6 05-13-2011 12:52 AM
Extract from String using Wildcard whousedmy Word 0 05-21-2009 01:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft