Add space between numbers

[Hema]

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

 

[Jacob Skaria]

Hi Hema

--Select the cell range.
--Right click>Formatcells>select 'Custom'>Type: (the below text)

## ## ## ##
--Try entering the numbers now

If this post helps click Yes

 

[Ashish Mathur]

=TEXT(H20,"00 00 00 00")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com