| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting cells
This would not be a formatting issue, but if the data is same throughout the
column you could parse the data and concatenate it to look the way you want it to. The following formula parses the data in A1 an inserts spaces after the 3rd and 7th characters: =LEFT(A1,3)&" "&MID(A1,4,3)&" "&RIGHT(A1,3) -- Kevin Backmann "5631" wrote: How should I format a cell to see 'aaa 1234 bbb' if a cell value is 'aaa1234bbb' ?  -- 5631 ------------------------------------------------------------------------ 5631's Profile: http://www.excelforum.com/member.php...o&userid=33022 View this thread: http://www.excelforum.com/showthread...hreadid=528465 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
| Formatting a group of cells for text | Excel Discussion (Misc queries) | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| Excel should allow more options for formatting cells | Excel Worksheet Functions | |||
| How to copy "edge" formatting to other cells. | Excel Discussion (Misc queries) | |||
Threaded Mode
