without space

B

bijan

i have three colum and i want save these in a text file without space between
colum.
 
B

Bob Phillips

Nick was asking you how you wanted the data if not with a space.

For example. say the columns had ABC, 123, and P34 in them, do you want to
see the out put as

ABC123P34

as one long string, or

ABC,123,P34

as comma separated values, or something else?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
B

bijan

i need this format ABC123P34

and i set the format colum custom with this 000000
therefor when i put 123 i got 000123 and when i use =a1&b1 in cell c1
it eliminate 000 i want have 000 in my cell c1
 
Top