Hi
I have a sheet which has in column E a text description , no restriction on length within that description, somewhere , and not in the same place within the text is a 7 digit number starting with 21, is there a way I can pull that seven digit number from the text into another cell ?
eg cell E2 contains 7 fruit lane 2187961 by james and murray
cell E3 contains murray and erica for 2187123 apple street
cell E4 contains 2196501 jack and paul the crescent
I want to have say cell H2 show 2187961
H3 show 2187123
H4 show 2196501
Any help greatly appreciated
Thanks
Rickf
I have a sheet which has in column E a text description , no restriction on length within that description, somewhere , and not in the same place within the text is a 7 digit number starting with 21, is there a way I can pull that seven digit number from the text into another cell ?
eg cell E2 contains 7 fruit lane 2187961 by james and murray
cell E3 contains murray and erica for 2187123 apple street
cell E4 contains 2196501 jack and paul the crescent
I want to have say cell H2 show 2187961
H3 show 2187123
H4 show 2196501
Any help greatly appreciated
Thanks
Rickf