Selecting part of the text

sadia

New member
Joined
Jan 26, 2013
Messages
14
Reaction score
0
Points
0
[h=5]Hi,

1892613130010
1892613130020
1892613130039
1896131300049
1896131320058
1892619195968
1892617172656

How to hide/ remove the first five default number (18926) in a cell[/h]
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
=mid(a1,6,99)
 
Top