Add space between numbers

H

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
 
J

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
 
Top