View Single Post
  #1   Report Post  
Kendosan1
 
Posts: n/a
Default Prepending text to a cell entry

How can I prepend the contstant string "S" to each numeric value entered into
the cells in a column? For example, if a user enters "12345" into a cell, I
want the cell value to be "S12345".