Microsoft Office Forums - View Single Post - [Solved] Extract text from a text string

Thread: [Solved] Extract text from a text string

View Single Post

Old

02-11-2017, 09:10 AM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

Or

=TRIM(LEFT(RIGHT(SUBSTITUTE(D4,".",REPT(" ",100)),200),100))

Reply With Quote