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
Can you please add an example in A2 cell?
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
Please review the formula.
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.
