Thread: Cell with numbers and names, need to devide them
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lion2004 Lion2004 is offline
external usenet poster
  
Posts: 16
Default Cell with numbers and names, need to devide them
Hello,

I have list of names and digits from A1 to A100. It is shown as
"PeeterXcrter 5696959594"
I need to devide 1 cell thisway, that this number will go to B row.

Thank you for help.

Peter
Reply With QuoteReply With Quote