| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I extract characters from inside a cell?
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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I extract characters from inside a cell?
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 On Sep 13, 4:54 pm, Eric wrote: 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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I extract characters from inside a cell?
Thanks for the tip, but what if i have an entire column to extract data from?
is there a way to automate this task? "Pete_UK" wrote: 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 On Sep 13, 4:54 pm, Eric wrote: 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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I extract characters from inside a cell?
Use Pete formula and drag all the down as far as needed.
"Eric" wrote: Thanks for the tip, but what if i have an entire column to extract data from? is there a way to automate this task? "Pete_UK" wrote: 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 On Sep 13, 4:54 pm, Eric wrote: 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) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I extract characters from inside a cell?
=MID(A1,2,4) if you want it as text or =--MID(A1,2,4) if you want it as a
number. -- David Biddulph "Eric" wrote in message ... 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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easiest way to extract characters in a cell LEFT or RIGHT of a sym | Excel Worksheet Functions | |||
| counting characters inside a cell | Excel Discussion (Misc queries) | |||
| Extract characters from a cell | Excel Discussion (Misc queries) | |||
| How do I extract 3 numbers inside a longer number to another column ? | Excel Discussion (Misc queries) | |||
| HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
Hybrid Mode
