Math, asked by shubhamkataria4599, 1 year ago

excel formula fto find second space from right

Answers

Answered by ADhruv11111

0

IF(ISERROR(FIND(" ",A2,FIND(" ",A2,1)+1)),A2,LEFT(A2,FIND(" ",A2,FIND(" ",A2,1)+1))) into a blank cell where you want to locate the result,

Previous Question

Next Question

Similar questions

Math, 6 months ago

lo) solve the following equation a) 2*3 + - 7*15 +3...

Math, 6 months ago

please help me with this logatithm problem...

History, 6 months ago

Check your understanding by unscrambling the answers given in brackets. 1. The person who devised the Ryotwari System (OMTSAH OUMRN) 2. The commercial crop grown in western India, for export to China (PMIUO) 3. Cash crops were grown on these large estates owned by Europeans (TTINPALAON) 4. Peasants did not grow food crops due to commercialisation of agriculture, leading to this situation...

India Languages, 1 year ago

Swami sai gajanan maharaj mandir shegaon...

Hindi, 1 year ago

Subsidiary alliance system was started by...

English, 1 year ago

letter to your uncle about inquiring an accident...

Math, 1 year ago

answer this question ??????????????????

Math, 1 year ago

please solve questions c and d...