without space

[Guest]

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

 

[Nick Hodge]

Bijan

Do you want any delimiter? comma, tab??? If not do you want them fixed
width. That is does each entry in a column have the same number of
characters?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[Guest]

i dont undrerstand could you say exactly what must i do

 

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

 

[Guest]

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

 

[Nick Hodge]

Bijan

=A1&TEXT(B1,"000000")

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk