Can you please help me? I have cells filled with strings broken by Chr(10).
The Chr(10) was manually added by alt+enter. I would like to copy these individual lines in separate cells.
I think it may be done by functions InStrRev, InStr, Mid and For loop, but will be a bit of challenge. Is there a more simple way?
Can't test it right now but there are a couple of options that should work. In code, you could use Split with the delimiter Chr(10).
But you could probably us Text to Columns, delimited and, in the Other box, hold down the Alt key and press 010 on the numeric pad.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks