CONCATENATES

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?????????
 
Maybe you have trailing spaces in your data:

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

=trim(a1)
will remove leading, trailing and change multiple consecutive spaces to one
(internally).
 
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
 
Back
Top