• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 893
  • Last Modified:

Extract information from cell

I have a spreadsheet where column A will have numbers (example as follows):
101611/1200001630

I need to extract everything after the first "/". The characters after the "/" could be both numbers and alpha and of various length (4 - 20 length).

Thank you in advance.
0
Farah Mohammed
Asked:
Farah Mohammed
  • 2
3 Solutions
 
NBVCCommented:
Try:

=MID(A1,FIND("/",A1)+1,255)
0
 
Saqib Husain, SyedEngineerCommented:
Another formula

=Replace(a1,1,find("/",a1),"")
0
 
Saqib Husain, SyedEngineerCommented:
If you simply want to get rid of the characters upto the / you can do

Data > Text to columns > Delimited > / > select the first column > Select "Do not import"
0
 
Farah MohammedBuyerAuthor Commented:
All three solutions worked perfectly. Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now