Sorry, i should have explained it more clearly. I actually want to keep
the data that is in the cells but insert a | before any existing data.

eg.

data - |data
more - |more

I hope this can be done, and thanks for the reply.

Lewis.


--
doof205
------------------------------------------------------------------------
doof205's Profile: http://www.excelforum.com/member.php...o&userid=28058
View this thread: http://www.excelforum.com/showthread...hreadid=475752