Questions

How can I transfer some characters to each separate cell

Tags: Windows
+
0 Votes

How can I transfer some characters to each separate cell

meisobs
Hi
I want to transfer many data in one cell to each separate cell in down. but it is so important first 3 characters of A1 transfer in down and then cell A2 transfer below of data in cell A1. could you give me formulate how can I do it?

A1: A06F002120 | A04L000900 | A06F001516 | |
A2: B63B000106 | B63H000508 | B63H0005125

A1: A06F002120 |
A2: A04L000900 |
A3: A06F001516 |
A4: B63B000106 |
A5: B63H000508 |
A6: B63H0005125 |

and next question how can I remove repeat data in one culuomn after finish my first question

Member Answers