How can I use cell formating to add * symbol to the begining and end of the text in a cell regargless of its contents. I need to do this to convert a large list of serial number to a barcode font.
Re: Need to add * symbol to the begining and end of every ce
mrhague said:
How can I use cell formating to add * symbol to the begining and end of the text in a cell regargless of its contents. I need to do this to convert a large list of serial number to a barcode font.
Re: Need to add * symbol to the begining and end of every ce
If you DO need to affect the values, the following macro will do the trick:
Code:
Sub Add_Stars()
Dim ThisCell As Range
Dim MyRange As Range
Set MyRange = Range("A1:G15")
For Each ThisCell In MyRange
If ThisCell.Value <> "" Then
ThisCell.Value = "*" & ThisCell.Value & "*"
End If
Next ThisCell
End Sub
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.