Paste Special?

[techj...@gmail.com]

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

[Bernard Liengme]

Don't do it with copy & paste; use a formula
="*" & A1 & "*"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

<techj...@gmail.com> wrote in message
news:3c6db4af-0173-4b85...@d7g2000prl.googlegroups.com...

[techj...@gmail.com]

On Mar 25, 11:27 am, "Bernard Liengme" <blien...@stfx.ca> wrote:
> Don't do it with copy & paste; use a formula
> ="*" & A1 & "*"
> best wishes
> --
> Bernard V Liengme

> Microsoft Excel MVPhttp://people.stfx.ca/bliengme
> remove caps from email
>
> <techjoh...@gmail.com> wrote in message

>
> news:3c6db4af-0173-4b85...@d7g2000prl.googlegroups.com...
>
> >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

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

[google...@yahoo.com]

On Mar 25, 12:18 pm, "techjoh...@gmail.com" <techjoh...@gmail.com>
wrote:

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).

[techj...@gmail.com]

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

[dranon]

If A16 really looked like that, it would be a circular reference.
STOP THAT!

>My B1 cell looks like this 123

>When I go to copy B1 into A16

I think you want A16 to say:
="*" & B1 & "*"

[techj...@gmail.com]

On Mar 27, 4:56 pm, dranon <dra...@dranon.invalid.net> wrote:
> On Thu, 26 Mar 2009 08:53:25 -0700 (PDT), "techjoh...@gmail.com"

Perfect!

Thanks,

--tj