you don't mention if you have need for a formula or a macro:

here's a formula, write back with more info about the sheet layout if you
want code.

=RIGHT(A1,LEN(A1)-FIND("#",A1))

--

Gary


"Mike" wrote in message
...
Thanks for any help.
How can I get Everytthing to the left of a character.
Examples od data
Tobacco Outlet #1
TRO #1
Tobacco Road Outlet #1
Needs to return 1
Tobacco Outlet #1201
TRO #1201
Tobacco Road Outlet #1201
Needs to return 1201