Thread: [Solved] other than number
View Single Post
 
Old 02-17-2012, 07:06 AM
gsrikanth gsrikanth is offline Windows XP Office XP
Competent Performer
  
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default other than number
i have numbers
like
234-1
1-1
12/a
101a

out put i need
234
1
12
101

other than number
sub number i don't need
subnumber are divided by /, -,.,\ ,text etc.,
Attached Files
File Type: xlsx Book1.xlsx (15.2 KB, 10 views)
Reply With Quote