How do I search for a number in a string in excel?
- 1 Answers
- 690 Views
- I also Faced
- E-Mail Answers
Answer / Lata
You can use the SEARCH or FIND function to find a number within a string. For example, if you have a cell A1 with the text 'Phone number: 555-1234' and want to find the phone number, you could use the formula: =SEARCH(' ', A1) + 8 (or FIND(' ', A1)+8) to return the starting position of the number, then use LEFT or MID functions to extract it.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is ms excel and explain the features of ms excel?
How do I match two lists in excel?
How do I change the default font for excel and word?
How do I use an if function in excel?
What is the role of scenario analysis?
How do I apply multiple conditional formatting rules in excel?
How do you use tables in excel?
In excel, how can I prevent a row from printing in a range if certain cells in a particular column equal 0. I do not want to extract the records to another section of thesheet. Is it possible to hide those rows, then print, then unhide?
How do I link cells in different excel workbooks?
How do I match a column in excel?
What is menu bar in ms excel?
How do I show the toolbar in excel 2010?
MS Excel Microsoft 
