#### Deepak Sharma

##### Member

Please provide a formulate to separate these in three columns or whatever is the best way to filter it out pls.

Column A2 is filled with ABC-000002

Column A3 is filled with ABC-000002-001

So, basically, I want to filter out these two things, so, i was thinking to use text to column, but that doesn't show initial zeros, then applied this, below formula to divide this into other columns than, I can combine...like that.

=LEFT(A2,SEARCH("-",A2,1)-1)

this is giving me result as ABD in column B2, And also applied MID function in column C2 but not getting it accurately. So basically I hope you under stood what I am in need of.

Thank you !