Help extracting specific information from cell A

[Mikelowrey]

Hi all,

I have a CSV that has all the information on cell A (instead of different cells for each information). Within Cell A, I would like to extract first and last name and move them to different cells (firstname to cell b and last to cell c)

Is it possible to get the first and last out?? This is what I currently have in Cell A

956855,<a href='https://domain.org/view/1/@TAXID=951565' target='_blank'>URL</a>,2023-08-17,JOHN,DOE,166779,PROFESSION,WORK

Thank you

 

[Dave Patton]

Try Data Text to Column with delimiter of , and in the last screen deselect all except the names

 

[Mikelowrey]

Try Data Text to Column with delimiter of , and in the last screen deselect all except the names

Thank you!

 

[Dave Patton]

Thanks for the feedback.