Creating white spaces in excel cells - Problem with REPT function

[Alexsander]

Hey guys.

I need help with some problems I'm having using the REPT function.

I am preparing a spreadsheet, where there is a sequence of fields that will contain specific information and this information will be pasted into a notebook. Some of these fields must be blank, keeping the text string.

I tried to use the REPT function to insert the blank spaces, however when I copy the information to notepad there is a giant spacing (as in the picture) and then there is the amount of spaces that I inserted with the function and at the end another giant spacing.

How can I solve this problem? Are there any other alternatives so I can insert these blanks?

 

[Alex Blakenburg]

Excel is adding a TAB between each column.

You have 365. Add a helper column at the end and use

=TEXTJOIN("",TRUE,A2:B2)

And copy that column to Notepad.

20211127 Text with spaces adding Tab.xlsx
	A	B	C
1	Column 1	Column 2	Combine
2	1	test	1 test
3	1	test	1test
4	a	b	ab
Sheet1

Cell Formulas
Range	Formula
A2	A2	="1" &REPT(" ",20)
C2:C4	C2	=TEXTJOIN("",TRUE,A2:B2)

 

[Peter_SSs]

Add a helper column at the end and use

=TEXTJOIN("",TRUE,A2:B2)

Same result as this?

=CONCAT(A2:B2)

 

[Alex Blakenburg]

Same result as this?

=CONCAT(A2:B2)

Did not even occur to me. That is even cleaner.

 

[Peter_SSs]

Did not even occur to me.

I guess even shorter would be ..

=A2&B2

 

[Alex Blakenburg]

I guess even shorter would be ..

=A2&B2

That I thought of as soon as you mentioned CONCAT but I would be surprised if the OP is really only exporting 2 columns.

 

[Peter_SSs]

... I would be surprised if the OP is really only exporting 2 columns.

Quite possibly so.