Extract Characters =MID(D2,2,3) (If requirement)

[sakrams]

Hi Guys,


I need your help with an excel sheet (File Links below).

https://ufile.io/qois1
or
https://files.fm/u/wmmtttcc



In column "C” I am trying to get 2nd, 3rd and 4th character/number if the Name is starting with "0". If it is not starting with "0" then i need the first 4 characters.


The current formula I have gives me the 2nd, 3rd and 4th character, but the adjacent columns Vlookup does not work unless I copy and paste that column as text and convert them all to number.


Any tip will be highly appreciated.

 

[Rick Rothstein]

Give this formula a try...

=0+LEFT(D2,4)

 

[FDibbins]

Can you show some samples here please? Im not going to strange-looking file hosting sites

 

[sakrams]

A2 = =VLOOKUP([@Unit],$F$1:$H$6,2,0)
B2 = =VLOOKUP([@Unit],$F$1:$H$42,3,0)
C2 = =MID(D2,2,3)

Can you show some samples here please? Im not going to strange-looking file hosting sites

 

[sakrams]

Awesome.. This worked perfectly. Thank you so much.

 

[sakrams]

Awesome.. This worked perfectly. Thank you so much.

[TABLE="width: 194"]
<tbody>[TR]
[TD]Awesome.. This worked perfectly. Thank you so much.




[/TD]
[/TR]
</tbody>[/TABLE]

Give this formula a try...

=0+LEFT(D2,4)