Microsoft Office Forums - View Single Post - [Solved] Extract all characters from the nth number of a string

Thread: [Solved] Extract all characters from the nth number of a string

View Single Post

Old

02-24-2020, 07:13 AM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows 10

Windows 10 jeffreybrown uses Office 2016

jeffreybrown uses Office 2016

Office 2016

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown 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