| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove number from string in excel
=MID(Sheet2!A1,27,99)*1
Vaya con Dios, Chuck, CABGx3 "Chris" wrote: Hi, I have the following string: "No. of Unsuccessful Calls: 1" I would like to link to the number in this cell only from sheet one (this string is in cell A1 of sheet 2) Thanks C |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting the number of instances of a string within another string | Excel Worksheet Functions | |||
| remove text from string | Excel Worksheet Functions | |||
| help with excel number string | Excel Discussion (Misc queries) | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
| remove leading zero from a string.. | Excel Worksheet Functions | |||
Hybrid Mode
