Thanks for all the feedback. It ended up being easier for me to just go back in and manually put in the hard returns. I'll spend some time playing with the substitute function, but in this particular instance, I think it would have been more effort than it would have been worth.
I was trying to alter text strings that were in 55 consecutive columns. There was a six digit number appearing at the end of each string that I needed to force onto its own line within the cell, just for clarity's sake.
In retrospect, I suppose it would have been quite easy to just remove the last six digits from the string and put them in a separate cell below... well, it's good to be able to have alternative solutions at our disposal.
Was this reply helpful? (0) (0)