Adding a character to the beginning and end of txt in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I would like to know if i can add a [ or ] or " to both ends of some text
in many different cells.
Is there a way of doing this?
 
Try entering this in a new column ="["&cellreference&"]"

I would then copy and paste the range as values on top of the original data.
 
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

adding text to the end of a formula 1
Adding the total # of characters in multiple cells 3
Way do do search/replace on beginning/end of cell w/o functions? 1
Removing 2-3 characters at the end 5
Restricting Number of characters in a cell 9
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
End/Beginning of Cell Search/Replace? 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top