ExcelBanter - Seperating text within a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Seperating text within a cell (https://www.excelbanter.com/excel-discussion-misc-queries/172509-seperating-text-within-cell.html)

Alan

Seperating text within a cell

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?

Roger Converse[_2_]

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?

All times are GMT +1. The time now is 02:22 AM.