| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
find and delete text, find a 10-digit number and put it in a textbox
It actually didn't take too long to find a solution myself. Sorry!
My own solution: If IsNumeric(Right(TextBox2.Text, 11)) Then TextBox3.Value = Right(TextBox2.Text, 11) TextBox2.Value = Application.Substitute(TextBox2.Text, Right(TextBox2.Text, 11), "") End If |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel find 5 digit number and replace with leading zero | Excel Discussion (Misc queries) | |||
| Find the First Digit in a Text String | Charts and Charting in Excel | |||
| how can i find samelest number and delete them | Excel Discussion (Misc queries) | |||
| How or where do I find my 25 digit license number teacher version | New Users to Excel | |||
| How to find the lowest number of a row and delete it automatically | Excel Discussion (Misc queries) | |||
Threaded Mode
