Jul 12 2020 11:29 AM
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.
Take a string of text (的一是了不) in Word and either,
1. Have Word automatically insert a space or tab between each character;
2. When pasting into Excel, have the characters be listed in A1, A2, A3, A4 and A5, and not all in A1.
I'm attaching screenshots for reference.
Jul 19 2020 02:15 AM
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