remove numbers from cell

juster21

Well-known Member
Joined
Jun 3, 2005
Messages
867
I have some cells that look like this..."### ####"
I want to remove everything except the last four numbers. Can this be done?
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

juster21

Well-known Member
Joined
Jun 3, 2005
Messages
867
a little more...

basically I have 3 numbers, 2 spaces and 4 numbers. I need to remove everything except the last four numbers
 

Watch MrExcel Video

Forum statistics

Threads
1,118,168
Messages
5,570,650
Members
412,335
Latest member
cinciri99
Top