Thread: How can I remove 4 of 9 numbers from a cell for the whole column?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default How can I remove 4 of 9 numbers from a cell for the whole column?
Insert column to right of the column containing your data

Data==Text-to-Columns=Delimited=Other ..enter "-" (no quotes) then Finish.

Delete redundant data i.e one containing the 4 digits.

HTH

"RISXRAY" wrote:

Example...

1234-56789 becomes 56789
Reply With QuoteReply With Quote