RE: Re: OT: Excel expertise required

["Graham Howe" <graham@xxxxxxx>]

> 
> You could try this:
> 
> If you start with data like
> 
> 1.2.3.4.5.6.7.8.9
> 
> in a2.a1000 (say)
> 
> select a2.a1000 and go Data...Text to Columns
> Tell the wizard you want 'delimited' then that the delimiter 
> 'other' is the full stop, and hit enter. This will split your 
> data conveniently into one column per number
> 
Thanks Joseph (and Mark Boyce who emailed the same solution privately).
This is exactly the sort of 'trick' I was looking for. After more years
than I care to admit of working with Excel, I had never used 'text to
columns' with anything other than CSV, space or tab delimited data. It
should do exactly what I need.

Regards

Graham

Yahoo! Groups Sponsor

ADVERTISEMENT

http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx 
Subscribe:  ukha_d-subscribe@xxxxxxx 
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
List owner:  ukha_d-owner@xxxxxxx
List of UKHA Groups here - http://groups.yahoo.com/group/UKHA_Grouplists/

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.