Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need a marco that can be use to delete the name in a cell in the
whole column and keep the number only (4042989) A 1 FRED ELMS (4042989) 2 CLIFFORD LEE (I-4042705) 3 HOANG HUYNH (4044099) 4 BRENT FAUGHT (4043945) 5 ELIZABETH LAND (4044665) 6 TIFFIN FRIESE (4044885) 7 TIFFIN FRIESE (4044885) 8 FRANK KOLARZ (4044048) 9 ALEJANDRO SANCHEZ (4041452) 10 BRENT RAMOS (4045946) 11 BETTY EHMEN (4045474) 12 BRANDA REAVES (4045546) 13 JAMES BISHOP (4045820) 14 ELIZABETH BURKE (4045844) 15 MORRIS DEVORE (4045835) 16 JULIE RENSHAW (4044396) 17 WILLIAM THOMASON (4044207) 18 GEORGE FOBIA (4044664) Any help would be appreciated. Chuong Nguyen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete part of a text string | Excel Worksheet Functions | |||
Marco that Delete Cells With Specific Text | Excel Programming | |||
Marco to delete all rows except those containing 'MZ' in string | Excel Programming | |||
Use a formula to delete part of a text string? | Excel Worksheet Functions | |||
Macro to delete last charcter in a text string | Excel Programming |