hi im trying to create a macro that with take multi line text
eg:
this
is
text
and put it all on the one line by either splitting and joining an array or replaceing all the CrLf so it looks like
this is text
any help would be appreciated
hi im trying to create a macro that with take multi line text
eg:
this
is
text
and put it all on the one line by either splitting and joining an array or replaceing all the CrLf so it looks like
this is text
any help would be appreciated
Last edited by Aussiexile; 10-07-2010 at 08:39 PM.
Use data > text to columns, with line feed as a delimiter?
Entia non sunt multiplicanda sine necessitate
i need all the data in the one cell.
it will be taking a title from a document which may encompas multiple lines and putting it on the one line in a single cell
EDIT: I solved the issue with this bit of code
tempTitle = Replace(strIn, Chr$(10), " - ")
thanx to all those that helped
Last edited by Aussiexile; 10-07-2010 at 08:38 PM. Reason: solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks