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?
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
 
You must log in or register to reply here.

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

Similar Threads

Excel Typed text appears in wrong cell 0
Separating prefixes in names 1
I can't copy and paste equations 0
update a word as a prefix in a column for all rows. 2
Quote Marks Question 2
How do I keep fill color constant when cut & copying text? 4
Access Tidy up phone numbers 0
Space in text 2

Back
Top