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.
|