2006-08-30 16:07:30 · 4 answers · asked by tn h 1 in Computers & Internet ➔ Software
Use the FIND function.
2006-08-30 16:12:12 · answer #1 · answered by Anonymous · 0⤊ 0⤋
Are you attempting to repeat from one excel e book to a distinctive ? if so the this could be basically somewhat an prolonged way around in spite of the shown fact that it works. reproduction the chosen lines onto yet another worksheet (say sheet 2) interior the excel e book. save the excel e book. Then open a clean one up , from the advice menu pick import from document and come across the workbook from above. Then decide on the worksheet (interior the occasion sheet 2) interior the workbook that has the advice you wanted
2016-09-30 04:49:18 · answer #2 · answered by ? 4 · 0⤊ 0⤋
I don’t know if this is what you are looking. But I can give small help with this. I can explain a small sample.
- Type “ABC3DEF” in cell A1 with out double quotes
- Click cell B1
- Type “=SEARCH(3,A1)” with out double quotes
- This will show the answer as 4 since the number is in the 4th location
In case if you are using the FIND function, you can replace the B1 cell content as =FIND(3,A1)
2006-08-30 16:21:58 · answer #3 · answered by Nishan Saliya 4 · 1⤊ 0⤋
see at top left of your document in address bar.
2006-08-30 16:13:53 · answer #4 · answered by aaayush 2 · 0⤊ 0⤋