Forum Discussion

Copper Contributor

Jul 23, 2021

Formula

I have two no in one cell and i want addition of that two no in another cell which formula I have to use please guide

Silver Contributor

Jul 23, 2021

IF you are using Excel 365 and IF your cells/range is called 'input' and IF each cell comprises two numbers separated by a comma, then

= LET(sep, ",",
  p,      FIND(sep, input),
  first,  MID(input, 1, p-1),
  second, MID(input, p+1, 15),
  first+second )

otherwise you need something different!