Daily tips for using Microsoft Excel.

Thursday, February 28, 2002

Jason asks "I am trying to make a cell reference that always automatically adds a * to
the beginning and end of the data.

For example, I put 12345 into cell A1. Then in cell B1, I want it to
automatically say *12345*

Ive tried doing a formula in cell B1 like ="*"=B1"*" or =("*"(=B1)"*") but
i cant think or a way to do it. The reason im trying to do this is because
im trying to make a bar code and it needs a * at the beginning and end of a
number for it to work. Please help"


You were close. Try with

="*"&A1&"*"

in B1.