I want to convert a list 50-100 serial #'s of varying length to comma delimited text with equal character spaces used.
COLUMN EXAMPLE:
12345678
1n234567
1n234567-1
RCn234567
12345678-90
6x789012-34
Converted to: 12345678 , 1n234567 , 1n234567-1 , RCn234567 , 12345678-90, 6x789012-34
Pasting this line of text into form fields of limited width force it into 2-4 columns of equal width making it easier to read.
Sample pasted into small field that forces auto-wrap:
The snip of Notepad file emulates the form field because it uses simple font where all characters use same amount of space.
I've tried to CONCAT, TEXTJOIN and Find/Replace in MS Word (doesn't recognize column markers as delimiters marks), just can't figure out how to maintain constant (in this case 11) character spaces.
COLUMN EXAMPLE:
12345678
1n234567
1n234567-1
RCn234567
12345678-90
6x789012-34
Converted to: 12345678 , 1n234567 , 1n234567-1 , RCn234567 , 12345678-90, 6x789012-34
Pasting this line of text into form fields of limited width force it into 2-4 columns of equal width making it easier to read.
Sample pasted into small field that forces auto-wrap:
The snip of Notepad file emulates the form field because it uses simple font where all characters use same amount of space.
I've tried to CONCAT, TEXTJOIN and Find/Replace in MS Word (doesn't recognize column markers as delimiters marks), just can't figure out how to maintain constant (in this case 11) character spaces.