| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
Thanks Lori,
That was perfect for me  Cheers, Chris. Lori wrote: > Format cells with the custom number format "0 0 0 0 0 0 0" or use a > text formula: > > =TEXT(A2,"0 0 0 0 0 0 0") > > c...@vvsii.com wrote: > > > Hi, > > > > I have a column of data that contains account numbers and they are > > always 7 characters long. > > > > Ex: > > > > 1125571 > > 1125585 > > 1125599 > > 1125611 > > 1125619 > > 1125675 > > > > > > I need to be able to add spaces between all of the numbes i.e. 1125571 > > would become 1 1 2 5 5 7 1 and so on down the line. Is there an easy > > way to do this? > > > > Thanks, > > Chris. |
|
|
|
|
|||
|
Guest
Posts: n/a
|
no problem, thanks for the reply!
(E-Mail Removed) wrote: > Thanks Lori, > > That was perfect for me > > Cheers, > Chris. > > > Lori wrote: > > Format cells with the custom number format "0 0 0 0 0 0 0" or use a > > text formula: > > > > =TEXT(A2,"0 0 0 0 0 0 0") > > > > c...@vvsii.com wrote: > > > > > Hi, > > > > > > I have a column of data that contains account numbers and they are > > > always 7 characters long. > > > > > > Ex: > > > > > > 1125571 > > > 1125585 > > > 1125599 > > > 1125611 > > > 1125619 > > > 1125675 > > > > > > > > > I need to be able to add spaces between all of the numbes i.e. 1125571 > > > would become 1 1 2 5 5 7 1 and so on down the line. Is there an easy > > > way to do this? > > > > > > Thanks, > > > Chris. |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| convert 5 characters in a cell to 6 characters by adding a zero | Helenf | Microsoft Excel Misc | 8 | 18th May 2009 04:43 PM |
| convert 5 characters in a cell to 6 characters by adding a zero | Helenf | Microsoft Excel Misc | 0 | 18th May 2009 03:08 PM |
| Limiting Characters in a cell and adding spaces to fill the remain | Melissa | Microsoft Excel Misc | 5 | 11th Jan 2008 02:35 AM |
| How do I insert spaces between characters | =?Utf-8?B?bWF5b3lv?= | Microsoft Excel Misc | 1 | 3rd Oct 2007 11:46 AM |
| Adding spaces between numbers in a cell that contains a full address | chunt@vvsii.com | Microsoft Excel Discussion | 4 | 6th Nov 2006 07:39 PM |
