spot_img

Cutting Pieces of Text After Particular Sign

In this Excel tutorial you will teach yourself how to cut a piece of text after some particular sign. Sometimes it happens that you receive some strange data. There are some part which you don’t need and it is hard to get rid of them. In this example you have data which begins with product code. Content which you need is after coma (,) sign.

 

There is a way in Excel to extract substrings. Just use this formula for: =MID(A2,FIND(“,”,A2)+1,LEN(A2)-FIND(“,”,A2)+1)

 

Paste this formula to your cell to extract data from A1 cell. Drag and drop down to extract data from another cells in A column.cutting pieces of text after particular sign

Different formula I know is =TRIM(MID(A2,FIND(“,”,A2,1)+1,100))

It works the same way. There is another proof that you can do the same things in different ways within Excel.

Template

You can download the Template here – Download
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell