tabs

F

Fabian

I use excel to autogenerate code for use in various scripting languages.
Is there any way to force a tab into a string generated using an excel
formula?
 
E

Earl Kiosterud

fabian,

Probably need a more specific question. Here are some possibilities for
what you want:

=A2 & CHAR(09) & B2
=concatenate(A2, CHAR(09), B2)
=A2 & "Some text, don't you know"

You may wish to define a name (like "tab")) for the tab character. Format -
Name - Define and in the "refers to" box:
=char(9)

then use it in your formulas:
=A2 & tab & B2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top