Hi,
Am using the following code to split the text at line breaks into new rows:
Afterwards I use the following basic text to column code to split it as per my necessity:Please Login or Register to view this content.
The problem is that all the leading and trailing spaces are left in the cells. How can I improve it to trim the results and replace the blank cells in one column with a specific word?Please Login or Register to view this content.
Many thanks in advance,
Paul
Bookmarks