In your attached file:
Select the data (A1:A5)
In the Data tab of the ribbon, choose Text to Columns in the Data Tools section and do the following:

2024-11-28_184526.jpg

click Next
In the next step ensure Treat consecutive delimiters as one is empty and the delimiter is set to only a comma, click Next

2024-11-28_184621.jpg


In the 3rd step select the first column at the bottom and choose the option button for that column to be Do not import column (skip), leave the rest of the columns as they are. In the Destination field choose a cell where the information is going to go and click Finish.


2024-11-28_184845.jpg


That's it.
However, it looks as though the data comes pasted from a text file of some sort, and if you're doing this on a regular basis it would be easier to import directly from the file using Power Query which is built-in to your version of Excel.