Adding a tab in between text and number

[dmb41]

I have two rows of data:

Parts Qty
234TV 2
541B 2
568WQ 5
049A 7
314YY 8

I need to input this into a .txt file and I need a tab in-between the part and qty (for the input it is going into).

I was going to use the function =CONCATENATE(A1," ",B1). Is there a way to input tab into functions?

 

[pgc01]

Hi

Try:

=A1&CHAR(9)&B1

 

[dmb41]

I think this is what I am looking for but when I copy and paste into notebook it puts quotes around it. Is there anyway to prevent this?

 

[MickG]

Try:-

=A1&" "&B1

 

[dmb41]

That only puts a few spaces in between and doesn't align when put in notepad (like a tab would do)

 

[pgc01]

Hi dmb41

The quotes are automatically inserted. They tell you that the tab inside is not a separator, it's a character of the string.

If you want to copy the text in the cells with a tab between them you can select them and copy them directly, like select A1:B1, copy, paste in notpad.


If you really want to copy the result of the formula to the notepad without the quotes I think you cannot do it directly, but you can write a small vba snippet to copy the text to the clipboard using a DataObject. This way you should have no problem when pasting it in the notepad.

 

[dmb41]

The problem is the program I am reading the .txt file into will not read in with the quotes.

It needs to be: part (then a tab) qty
e.g.: P205 9
Y908 10
... where all the numbers are lined up.

I tried to save as a tab deliminated form in excel. That will not work either.

 

[pgc01]

Try saving as prn.

I'm leaving now but I'll check in later.