View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Converse[_2_] Roger Converse[_2_] is offline
external usenet poster
 
Posts: 45
Default Seperating text within a cell

Hello,

You can goto Tools | Text to Columns

when the wizard appears, choose delimmited by period.

HTH
Roger

"Alan" wrote:

I downloaded a QuickBooks file into excel. One of the cells includes the
account number (4 digit charachter) a dot (spacer) and then the account name.
I can I break out the account number from the account name?