Try

=Left(A1,Find("#",A1))