[Claus Busch]

Hi,

Am Wed, 21 Sep 2016 12:37:17 +0100 schrieb Smurfy:

Ok the first two work but I guess I wasn't clear, I need to strip that
information out and leave the remaining. The formula you posted results
in removing the information I need.

try:
=MID(A1,FIND("#",SUBSTITUTE(A1," ","#",4))+1,99)


Regards
Claus B.
--
Windows10
Office 2016