Select the range, type the symbol, then press CTRL+ENTER
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"doof205" wrote in
message ...

I have a huge excel spreadsheet and i need to insert a | symbol at the
start of every cell. Obviously i dont want to do this manually and it'd
be nice to edit in some way so that this | symbol is automatically
inserted.

Does anyone have any ideas how this can be done?

Thanks for any help,

Lewis.


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