Paste Special?

  • Thread starter Thread starter techjohnny
  • Start date Start date
T

techjohnny

I have a column of part numbers that I'd like to copy and paste into
another column using a barcode font. The barcode scanner requires
that each part number has a * preceding and succeeding the number.
Can somebody help me where I should be looking in excel to make this
happen, without having to have the user type in a * before and after
the part number?

Regards,

--tj
 
Don't do it with copy & paste; use a formula
="*" & A1 & "*"
best wishes
Click to expand...

Thanks for the fast response. Alright, I was able to apply this to
one cell, but what if I already have a range of cells with data
currently populated?

Regards,

--jp
 
Thanks for the fast response.  Alright, I was able to apply this to
one cell, but what if I already have a range of cells with data
currently populated?

Regards,

--jp
Click to expand...

You should be able to insert a new column and paste the formula into
that column, working on the data that you already have populated. If
this doesn't work, can you post a small sample of what your data looks
like (the columns that have data, and the columns where you need the
barcode stuff).
 
You should be able to insert a new column and paste the formula into
that column, working on the data that you already have populated.  If
this doesn't work, can you post a small sample of what your data looks
like (the columns that have data, and the columns where you need the
barcode stuff).
Click to expand...

Here's my problem:

My A16 cell looks like this
="*" & A16 & "*"
My B1 cell looks like this 123

When I go to copy B1 into A16, A16 now just displays 123 in the bar
status bar. It overwrite the formula. I can manually go into A16 and
change A16 values, which is blue, but this requires that I manually
input the data one cell at a time.

Regards,

--jp
 
Back
Top