Issue
The need to add a suffix or prefix or suffix to a column of data. without having to go down line by line manually inserting the prefix or suffix you wanted inserting


Solution


  • Highlighted selected cells.
  • Go To format cells.
    • Select "Custom"


Type in the below (Put the suffix or prefix you want (We used * as an example) to insert, but you could change this for a different prefix)

(vary the number of # according to the digits in the barcode, or if they vary amend it to the longest barcode)

 

“*”#######”*” for a prefix and a suffix (“*”#”*”) should work if different character length are used

"*"######### for a prefix only

########”*” for a suffix only


Note

If you copy and paste the data, you will loose the suffix or prefix, unless the field has the same formatting. The other way would be to add a field before of after and concatenate the two fields. You would then want to copy and paste the values, to another field.


Office Concatenate Function


https://support.office.microsoft.com/en-gb/article/CONCATENATE-function-870e82a1-d47d-440e-9a77-23e7639eda1d?CorrelationId=e9d5c75a-72a7-4923-9217-27cfeda7e1e8&ui=en-US&rs=en-GB&ad=GB