I need to add an asterix before and after my data to convert it to 3of9
barcode font that we can scan. I can get it to go in using a Concatenate but
it leaves a bunch of spaces before it adds the closing asterix?????????

Maybe you have trailing spaces in your data:

="*"&trim(a1)&"*"

=trim(a1)
will remove leading, trailing and change multiple consecutive spaces to one
(internally).



gfrechette wrote:
>
> I need to add an asterix before and after my data to convert it to 3of9
> barcode font that we can scan. I can get it to go in using a Concatenate but
> it leaves a bunch of spaces before it adds the closing asterix?????????

--

Dave Peterson

Maybe you have a bunch of spaces after your data?

What do you get if you use a helper column and =LEN(cellref) on the original
data?

TRIM your data to remove the extra spaces if need be.


Gord Dibben MS Excel MVP

On Thu, 5 Jul 2007 15:44:03 -0700, gfrechette
<(E-Mail Removed)> wrote:

>I need to add an asterix before and after my data to convert it to 3of9
>barcode font that we can scan. I can get it to go in using a Concatenate but
>it leaves a bunch of spaces before it adds the closing asterix?????????