try this and see if it works for you

=IF(ISNUMBER(FIND("#",A1)),"The "&TRIM(LEFT(A1,FIND("#",A1)-1)),A1)

--


Gary


"bklim" wrote in
message ...

Hi Mangesh

Tq vry much for the prompt reply, and i tried it and found another
problem, it will not process title with #the but #The. Please advise.

Regards/BKLim



mangesh_yadav Wrote:
If your text is in A1, then use:
=IF(ISNUMBER(FIND("#The",A1)),"The
"&TRIM(LEFT(A1,FIND("#The",A1)-1)),A1)

Mangesh


--
bklim
------------------------------------------------------------------------
bklim's Profile:
http://www.excelforum.com/member.php...o&userid=24268
View this thread: http://www.excelforum.com/showthread...hreadid=378874