Export to text file where each cell is a character in the line

Hi there - I am stuck! I need to take rows of information and export them to a text file in a very specific way. Each cell in a row is a character, so when you export 100 columns of text, that should equal 100 characters in a line.

For example

A1 = 3
B1 = A
C1 = [space]
D1 = G

the output in the text file will be '3A G'

I can't see how this can be done with the save as and choosing any of the text file options, they seem to use delimited formats that do not match my needs. Is this a script? Anyone know what it would look like??

TC

Dave, you sir, are a legend. the concatenate worked. I had to find/replace the blank cells with a space as the import in to Excel originally leftthe cells blank rather than adding a space in to that cell. I am now all good - thank you!

TC

Originally Posted by FlameRetired

I am not aware of a method of saving files that will do what you want.

Not sure if this will do everything you want. There is a User Defined Function written by tigeravatar that will concatenate all those characters into a single cell. Saved as a text file it appears to do what you want. You may have to start a new workbook that references your data.

Please Login or Register  to view this content.

If you are not familiar with VBA copy the above code. Open the Visual Basic editor (Developer / Visual Basic; or use the keyboard shortcut Alt + F11). Click on Insert on the menu bar. Select Module. An editing window will appear. Paste the code into that window.

Return to the spreadsheet and enter

=concatall(A1:D1)

3A G should appear. This requires that C1 is an actual space character and not just a blank cell.

Concatenate solved my problem - thank you!