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 |