Issue
I have the following column :
A1
Miu Kei Yuk
3354
of
2018
8 April 2022
and need to separate it into 3 columns :
3354 of 2018
Miu Kei Yuk
8 April 2022
So the first and the fifth row are correct, but the row number 2, 3 and 4 needs to be in only 1 cell.
I tried transpose(A1:A5) but iu results in :
Miu Kei Yuk domingo, março 07, 1909 of 2018 8 April 2022
Is it possible to do it ?
Solution
try:
={A2&" "&A3&" "&A4, A1, A5}
or:
={A2&" "&A3&" "&A4\ A1\ A5}
Answered By - player0 Answer Checked By - Dawn Plyler (PHPFixing Volunteer)
0 Comments:
Post a Comment
Note: Only a member of this blog may post a comment.