| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add space between numbers
Hello,
Could you please guide me on how to include space betwen numbers. Input data - 12345678 , I need the output to be 12 34 56 78 Regards Hema |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add space between numbers
Hi Hema
--Select the cell range. --Right clickFormatcellsselect 'Custom'Type: (the below text) ## ## ## ## --Try entering the numbers now If this post helps click Yes --------------- Jacob Skaria "Hema" wrote: Hello, Could you please guide me on how to include space betwen numbers. Input data - 12345678 , I need the output to be 12 34 56 78 Regards Hema |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add space between numbers
=TEXT(H20,"00 00 00 00")
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Hema" wrote in message ... Hello, Could you please guide me on how to include space betwen numbers. Input data - 12345678 , I need the output to be 12 34 56 78 Regards Hema |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numbers followed by space | Excel Discussion (Misc queries) | |||
| How can I remove a space between a letters and set of numbers? | Excel Discussion (Misc queries) | |||
| How do I write a script to add space between numbers in a column? | Excel Discussion (Misc queries) | |||
| Extra space after imported numbers | Excel Discussion (Misc queries) | |||
| Space between decimal numbers | Excel Worksheet Functions | |||
Linear Mode
