Dear All,
i have a column with values in excel table:

       
ATGC22327-p66       
ATGC15922-p239       
ATGC12710-p21743567     
ATGC08037-p186       
ATGC07969-p173       
ATGC07345-p48534    
ATGC02767-p254234  
 ATGC02124-p2177451
ATGC02124-p1459     
 ATGC01930-p3005

p66
p239
p21743567
p186

'in excel table'? Do you mean a CSV file, flat file, or actual xls file?

Yes it is an excel file, I was trying to do in excel by opening text file,
this is actually a tab delimited text file
Best Regards

These are not the same thing. Knowing it's tab-delimited text is good.

Knowing which column you wanted would also be nice... I'm assuming it's the first and only column, but 'tab separated' has little meaning when there's no columns!

awk -F"-" '{ print $2 }' inputfile

Follow these steps:

1. Make a copy of this column to another column
2. Select all data in the new column
3. Goto Data tab
4. Select Text to Columns
5. Specify hyphen - as delimiter
6. Click Finish

Now you will have a new column with data starting with p

thanks, it works in excel,
but not in text file, it was second column,
Best Regards

Import the text into excel, nsert a blank column to the right of the column with the -p's, select the text, and do data text to columns, spliting on '-', as mentioned above.