Hi All,

Thanks in advance

I have the following sheet

Want the following result

tried the following but not find the result

1) IF(VALUE(MID($A2,COLUMNS($B$1:B1),1))=0,"",MID($A2,COLUMNS($B$1:B1),1))

Help pls

Thanks in advance

I have the following sheet

**Excel 2010 32 bit**A | |
---|---|

1 | 04 |

2 | 45 |

3 | 65 |

4 | 02 |

5 | 90 |

6 | 06 |

Sheet: Sheet1 |

Want the following result

**Excel 2010 32 bit**A | B | C | |
---|---|---|---|

1 | 04 | 0 | 4 |

2 | 45 | 4 | 5 |

3 | 65 | 6 | 5 |

4 | 02 | 0 | 2 |

5 | 90 | 9 | 0 |

6 | 06 | 0 | 6 |

Sheet: Sheet1 |

tried the following but not find the result

1) IF(VALUE(MID($A2,COLUMNS($B$1:B1),1))=0,"",MID($A2,COLUMNS($B$1:B1),1))

2) =MID($A2,COLUMNS($B$1:B1),1)

Help pls

Last edited: