| How to Separate Text and Number from a cell | by Let's Learn Excel
**Notification**
For some technical issues,I had to move on to new channel of Excel.This is the same excel channel of mine as you used to watch.
Hello and welcome to my Excel Youtube channel.Guys this video will show you how to separate text and number from cell in excel.Though there are many ways to do this,I've shown you few formulas to do it.
=Right()
This gives us piece of text from a given text in a cell starting from a desired number
=SUBSTITUTE()
Replaces a new text or value entry with a old piece of text or number in a cell
=LEN()
Gives the length of a text
=FIND()
Finds a number of position of desired text or number from a given text in a cell.
Guys please watch the video till the end and I'll be obliged if you learn something out of if.
My Excel Channel Link
/ @letslearnexcel6536
My other Channel Link
/ @debasishdebnath
Facebook: / debasish.debnath.5201
Twitter : / deba007007
Email :[email protected]