Convert string of text from Word to own line in Excel

Copper Contributor

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.

1 Reply

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 )

 

Snag_671efbb5.png

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