Forum Discussion
Convert string of text from Word to own line in Excel
I'm using the newest version of Office for Mac. I've been trying for hours and cannot figure out an automatic way to do this. A solution to any of the following would be extremely appreciated. ...
Hi helpneeded
These no paste method yet which paste each character into each cell. But you can use this formula which will fulfil your requirement
= MID ( $A1 , COLUMNS( $A$1:A$1 ), 1 )
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more