#1
|
|||
|
|||
How can I break a single group of words into three sets?
Hi,
How can I break the following group of words into three sets but in one Cell: Example: Querry: Cell "A1" = 0558476585 Result: Cell "B1" = 055 847 6585 Last edited by Learner7; 03-22-2011 at 03:25 AM. |
#2
|
||||
|
||||
Hi,
Assuming all of the numbers have 10 digits, this formula will do it: Code:
=LEFT(A1,3)&" "&MID(A1,4,3)&" "&RIGHT(A1,4) |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
paragaph hard break, soft break and ...strange break | czomberzdaniela | Word | 2 | 12-03-2010 06:58 PM |
2 sets of names and adresses. need to know which addresses have changed. (Picture) | spartanhockey | Excel | 6 | 01-27-2010 01:54 PM |
Finding the complements between the two data sets | psenku | Excel | 2 | 08-17-2009 11:15 PM |
How do I accept non-Western (non-latin) character sets | 3rd floor | Outlook | 1 | 02-10-2006 03:17 PM |
One bar chart for 3 sets of data | rclloyd | Excel | 1 | 02-03-2006 09:51 AM |