Forum Discussion
Extraction formula help
I need a formula to extract the AC-UG from the text string below and then put them in two separate columns without using the text-to-columns feature - TIA! EM-AC-UG-Course-ENG-122-Week3-TOT
The custom function AnyPart can do that.
It is part of the free "Custom_Functions" Excel add-in.
(20+ excel functions that work exactly like the built-in functions)
(filled across and then filled down)
Pay attention to the placement of the $ symbols.
Download the add-in from OneDrive...
https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU
A separate examples file is also available.
'---
Nothing Left to Lose