Thread: Help to extracting text from text string
View Single Post
 
Old 02-13-2019, 03:40 AM
Haha88 Haha88 is offline Windows 8 Office 2010 32bit
Advanced Beginner
  
Join Date: Mar 2015
Posts: 77
Haha88 is on a distinguished road
Default Help to extracting text from text string
Hi,

Can someone please help me to extract text from a text string? I could never understand and be able to work out the formula.

Journal:JNL002668::S J Elder:SS-RWDG01:RW DigitalS-12708:::: extract: "S J Elder"

I attached an example sheet.

Many thanks,
Anh
Attached Files
File Type: xlsx Example.xlsx (13.5 KB, 8 views)
Reply With Quote