[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
Solved

# Extract information from cell

Posted on 2012-09-13
Medium Priority
888 Views
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).

0
Question by:Farah Mohammed
• 2

LVL 23

Accepted Solution

NBVC earned 668 total points
ID: 38396054
Try:

=MID(A1,FIND("/",A1)+1,255)
0

LVL 43

Assisted Solution

Saqib Husain, Syed earned 1332 total points
ID: 38396080
Another formula

=Replace(a1,1,find("/",a1),"")
0

LVL 43

Assisted Solution

Saqib Husain, Syed earned 1332 total points
ID: 38396094
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

Author Closing Comment

ID: 38396260
All three solutions worked perfectly. Thank you.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
###### Suggested Courses
Course of the Month18 days, 11 hours left to enroll