Hi @Mohammad Asif
I agree with Barry Schwarz. It's best to share a sample to us.
Generally, split text in a cell, you may use TEXTSPLIT function or Text to Columns button. For some cases, you may use Left, Right, Mid or other formulas.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.