constant text prefix

C

chris n

Is there any way I can set up a spreadsheet so that / appears in front
( with no space) of the text that I paste in the cell?
 
R

Ron Rosenfeld

Is there any way I can set up a spreadsheet so that / appears in front
( with no space) of the text that I paste in the cell?
Click to expand...


Custom format the cell.

Format/Cells/Number/Custom/Type: \/@

Note that the text string should NOT be underlined, but the @ induces the
underline in this posting because of the possibility it might represent a URL.


--ron
 
Top