bar code help, adding asterix to reference

  • Thread starter Thread starter R D S
  • Start date Start date
R

R D S

Hi,
A simple one im sure, cell b4 contains a number, i want cell c4 to display
the same number with an asterix (asterisk?) at either side for my bar code
font?
="*",B4,"*"
What's the correct way to enter this?

Many thanks as ever,
Rick
 
="*"&A1&"*"

seems to work after some trial and error,
could there arise a problem doing it this way?

Thanks,
Rick
 

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

Include a value from one cell within text of another cell. 2
Continuing the cell references in formulas 8
Code to calculate 6
Can't get bar code font to work in EXCEL 2003 3
formula to change font colour depending on which cell it has used 1
Hyperlink via indirect cell reference 8
Vlookups Based on Validation Data 2
Comparing Text to Several Cells 4

Back
Top