How to insert tabbed text in a single excel cell
Importing data from sql to excel. The sql cell contains text with a tab.
When you import data into excel, the data is not inserted into a single cell, but is distributed over several cells. Tell me how to configure the cell format in excel so that data is inserted into a single cell, regardless of the number of line breaks and the amount of text in the source cell.
0
1 answers
Maybe it will be useful for someone. The solution is on the sql server side. In the request, wrap the field in the REPLACE function, replacing the hyphen with a space character. REPLACE(Your field, CHAR(10),' ')
0
Author: Алиса, 2019-08-13 10:22:00