View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mns mns is offline
external usenet poster
 
Posts: 23
Default Seperating numbers from text

Hi,
I am working on an excel file which has a column that contains product names
+ serial numbers. Dont know how but someone combined that data. they used to
be in different columns but now they are in same column and have no spaces
between them.
cells have names like this,
productname1345

is there any easy way to scan through the coulmn and at least seperate the
data like
productname 1345

after this step i think i can handle it:)

thanx for help.