| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting data
I have 000000VC3236 in a cell and I need only the last 4 numbers of 3236. How
can I extract that data? I have tried +SUM(MID(A1,3,FIND("VC",A1)-3)) . What am I doing wrong?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extracting data
On Aug 13, 12:08 pm, DestinySky
wrote: I have 000000VC3236 in a cell and I need only the last 4 numbers of 3236. How can I extract that data? I have tried +SUM(MID(A1,3,FIND("VC",A1)-3)) . What am I doing wrong?? You're on the right track. I would use =MID(A1,FIND("VC",A1)+2,4) ..o. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extracting data
Not sure why you're using the SUM function, but otherwise you were close.
Try this: =MID(A1,FIND("VC",A1)+2,99) HTH, Elkar "DestinySky" wrote: I have 000000VC3236 in a cell and I need only the last 4 numbers of 3236. How can I extract that data? I have tried +SUM(MID(A1,3,FIND("VC",A1)-3)) . What am I doing wrong?? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extracting data
You have answers to your early (< 10 minutes ago) posting: be patient!
"DestinySky" wrote: I have 000000VC3236 in a cell and I need only the last 4 numbers of 3236. How can I extract that data? I have tried +SUM(MID(A1,3,FIND("VC",A1)-3)) . What am I doing wrong?? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extracting data
=right(A1,4) as text
=--right(A1,4) if you want it as a number -- David Biddulph "DestinySky" wrote in message ... I have 000000VC3236 in a cell and I need only the last 4 numbers of 3236. How can I extract that data? I have tried +SUM(MID(A1,3,FIND("VC",A1)-3)) . What am I doing wrong?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help extracting data.... | Excel Worksheet Functions | |||
| Need help extracting data | Excel Discussion (Misc queries) | |||
| Extracting Data for .Txt Files By Unique Field Data | Excel Discussion (Misc queries) | |||
| Extracting data | Excel Discussion (Misc queries) | |||
| Extracting data | Excel Worksheet Functions | |||
Linear Mode
