Not sure what you're asking, but here are some examples:
Code:
SQL> select * from xyz;

X   Y          Z
--- ---------- ----------
001 83727#828  828273
002 #2882277   282727#22
003 273727#    282#28727#

SQL> select x || y || z from xyz;

X||Y||Z
-----------------------
00183727#828828273
002#2882277282727#22
003273727#282#28727#

  1* select replace(x || ' ' || y || ' ' || z, '#', '') from xyz
SQL> /

REPLACE(X||''||Y||''||Z,'
-------------------------
001 83727828 828273
002 2882277 28272722
003 273727 28228727