If I have two lines of dates in one cell, how do I delete the first line?
Md Ariful Islam
বিএসসি(সিএসই)
,
এমবিএ(মার্কেটিং)
4 views
1 Answers
Dr. Md Rushad Rahman
এমবিবিএস(আরপিএমসি)
,
পিজিটি(মেডিসিন)
Double click on the cell, or click the cell and then F2. Then, delete the part that you don't need. If you want to do this on a large number of cells on the same column, then select the column, click "DATA" on the top menu, click on "Text to Columns," and try the different options to divide the data there. (There are too many to list here.) You can divide by commas, spaces, dashes, periods, etc., or specify the length. Make sure the columns on the right are empty; the divided data will split into those columns.
4 views
Answered