# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have a row of letters and numbers i need to remove the letters and add them to another column. Example BSN17525
Solved by V. Q. in 19 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 02/10/2018 - 02:47
Hi, Welcome to Excel Chat.
Excelchat Expert 02/10/2018 - 02:47
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
Excelchat Expert 02/10/2018 - 02:48
Let me ask you a couple of quick questions to make sure I fully understand your problem.
Excelchat Expert 02/10/2018 - 02:48
You want to get the numbers from the text?
Excelchat Expert 02/10/2018 - 02:48
As an example, i have placed text in A1 cell.
Excelchat Expert 02/10/2018 - 02:48
You want to get 17525?
User 02/10/2018 - 02:49
yes and put the text in another column
User 02/10/2018 - 02:49
yes
Excelchat Expert 02/10/2018 - 02:49
Ok.
Excelchat Expert 02/10/2018 - 02:49
User 02/10/2018 - 02:50
I will end up with two columns one with numbers the other with the text all my text are three text
Excelchat Expert 02/10/2018 - 02:50
I have placed the formula as follows:
Excelchat Expert 02/10/2018 - 02:50
Ok. I have added formula in B1 for numbers and C1 for text.
Excelchat Expert 02/10/2018 - 02:51
Excelchat Expert 02/10/2018 - 02:51
=mid(A1,4,len(A1))
Excelchat Expert 02/10/2018 - 02:51
It is used to extract the number located at the end, starting from 4 th position.
Excelchat Expert 02/10/2018 - 02:52
I have used mid function in Excel. Mid (String,start position, length)
Excelchat Expert 02/10/2018 - 02:52
Similarly for text, here is the formula.
Excelchat Expert 02/10/2018 - 02:52
=mid(A2,1,3)
User 02/10/2018 - 02:52
what if I have information ABCSF1236
Excelchat Expert 02/10/2018 - 02:52
This formula won't work.
Excelchat Expert 02/10/2018 - 02:53
It is based on the pattern of text.
User 02/10/2018 - 02:53
what if all my information only need to remove the first three letters
Excelchat Expert 02/10/2018 - 02:54
If you want to have different patterns, then, a different formula is applied.
Excelchat Expert 02/10/2018 - 02:54
If you want to remove first 3 letters.
Excelchat Expert 02/10/2018 - 02:54
=mid(A1,4,len(A1))
Excelchat Expert 02/10/2018 - 02:54
This formula can be used.
Excelchat Expert 02/10/2018 - 02:54
It is for the cell A1.
User 02/10/2018 - 02:54
can the letters be moved to a different column
Excelchat Expert 02/10/2018 - 02:55
If you have many more, then you copy the cell downwards.
Excelchat Expert 02/10/2018 - 02:55
For letters, there is a different formula as shown in C1 cell.
Excelchat Expert 02/10/2018 - 02:55
=mid(A1,1,3)
Excelchat Expert 02/10/2018 - 02:55
It moves the first 3 lettes.
Excelchat Expert 02/10/2018 - 02:55
*letters.
User 02/10/2018 - 02:56
ok thanks I will give it a try.
Excelchat Expert 02/10/2018 - 02:56
Sure. Please try and let us know.
Excelchat Expert 02/10/2018 - 02:56
Got IT Pro has 24*7 support.
Excelchat Expert 02/10/2018 - 02:56
So, you can reach anytime.
User 02/10/2018 - 02:56
ok thanks
Excelchat Expert 02/10/2018 - 02:57
Thanks for coming to Excelchat. Feel free to leave any comments or feedback. Have a nice day.
Excelchat Expert 02/10/2018 - 02:57
Please end the session. Thank you.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.