Inserting TAB character into a text string inside a cell?

[teachman]

Hello, I would like to find a way to concatenate two tab characters to the beginning of a string in a cell. Example: A4 = "Alpha" A5 = "Zeta" A6 has =A4&" "&A5 Which displays as Alpha Zeta I would like to see TABTABAlpha Zeta I then copy that cell and paste into another document. Without the two TAB characters I have to manually insert the Tabs before I paste the cell contents that were copied. Can this be done? Thanks, George

 

[Rick Rothstein]

Try this...

=CHAR(9)&CHAR(9)&A4&" "&A5

 

[teachman]

Try this...

=CHAR(9)&CHAR(9)&A4&" "&A5

We're getting closer, Rick. But, when the situation is like this:

A4 = <column name="observation_date" column="C"
A5 = />
[TABLE="width: 293"]
<TBODY>[TR]
[TD]Then CHAR(9)&CHAR(9)&A4&A5 results in:
TABTAB<column name="observation_date" column="C"/>[/TD]
[/TR]
[TR]
[TD]
And when I copy this cell and paste it into Notepad the resut is:
[TABLE="width: 293"]
<TBODY>[TR]
[TD]"TABTAB<column name=""observation_date"" column=""C""/>"[/TD]
[/TR]
[TR]
[TD]
The extra quotes in the above are added somehow during the paste. They are NOT in the cell.

Thanks,
George[/TD]
[/TR]
</TBODY>[/TABLE]


[/TD]
[/TR]
</TBODY><COLGROUP><COL></COLGROUP>[/TABLE]

 

[teachman]

Try this...

=CHAR(9)&CHAR(9)&A4&" "&A5

We're getting closer, Rick. But, when the situation is like this:

A4 = <COLUMN
A5 = />
[TABLE="width: 293"]
<TBODY>[TR]
[TD]Then CHAR(9)&CHAR(9)&A4&A5 results in:
TABTAB<COLUMN column="C" name="observation_date" />
[/TD]
[/TR]
[TR]
[TD]And when I copy this cell and paste it into Notepad the resut is:


[TABLE="width: 293"]
<TBODY>[TR]
[TD]"TABTAB<COLUMN column="" name="" C?? observation_date?? />"
[/TD]
[/TR]
[TR]
[TD]The extra quotes in the above are added somehow during the paste. They are NOT in the cell.

Thanks,
George
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[/TR]
</TBODY>[/TABLE]