CONCATENATES

[Guest]

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 trailing spaces in your data:

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

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

 

[Gord Dibben]

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