How can I extract characters from inside a cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to extract portions of cell contents (i.e. B109912345 - i need the
1099 out of this info) and prot it to the cell to the right (next column)
 
If it is always going to be those characters (i.e. from the 2nd to the
5th inclusive), then use this:

=MID(A1,2,4)

If you need it to be numeric, then just multiply by 1.

Hope this helps.

Pete
 
Thanks for the tip, but what if i have an entire column to extract data from?
is there a way to automate this task?
 
=MID(A1,2,4) if you want it as text or =--MID(A1,2,4) if you want it as a
number.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting Data from a string of text in a cell 4
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Extracting part of a cell 6
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Extracting just the time portion 5
#value error for sumproduct using RIGHT cmd 0
Extract characters from Right of string 5
extract characters from filename 7

Back
Top