constant text prefix

  • Thread starter Thread starter chris n
  • Start date Start date
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?
 
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?


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top