AoA,
Basically i converted a list from pdf and now the first name middle name and last name are in different cells but i want to combine in one cell but as a different persons names consist of different Parts some has first middle and last where some have even on five portion plz tell me how to tackle this sjtuation i am uploading sheet for sample
https://drive.google.com/file/d/1rOtGyIbyEY8mTpecVqA8wrsb_G1TmYTu/view?usp=drivesdk
I did not find a way to upload a file
Basically i converted a list from pdf and now the first name middle name and last name are in different cells but i want to combine in one cell but as a different persons names consist of different Parts some has first middle and last where some have even on five portion plz tell me how to tackle this sjtuation i am uploading sheet for sample
https://drive.google.com/file/d/1rOtGyIbyEY8mTpecVqA8wrsb_G1TmYTu/view?usp=drivesdk
I did not find a way to upload a file
