Split words and text

[PumSese]

Hello everyone, is there a function to split words and numbers from one cell to two cells and if cell contains special character to split it into 3 cells?

[BadlySpelledBuoy]

Hi and welcome.

Could you could attach a sample workbook with a few example showing your original data and desired outcome?

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

BSB

[Hikari]

Hi PumSese

You can try to use the "Text to columns" function.

Go to "Data" --> under "Data Tools" ---> select "Text to columns"

Thanks

[PumSese]

I used same VBA function to split it. Still need to make it to work with special format used in worksheet.