Thread: How to separate the numbers and characters in the cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vino vino is offline
external usenet poster
  
Posts: 1
Default How to separate the numbers and characters in the cell
Hi buddies,
Anybody knows the macros for to separate the numbers and characters in
a cell please tell me.
For example,

1000Rs1000dollor 34,sdfj street, NY

into


1000 Rs 1000 dollor 34,sdfj
street,NY

Reply With QuoteReply With Quote