Extract all characters from the nth number of a string

		Microsoft Office Forums > Microsoft Excel > Excel
Extract all characters from the nth number of a string

FAQ

Thread Tools

Display Modes

02-24-2020, 07:13 AM

jeffreybrown jeffreybrown is offline

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 about

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))

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extract States from a String	soldat452002	Excel	9	04-26-2018 04:16 AM
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 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 04:26 PM.