ExcelBanter - Add space between numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Add space between numbers (https://www.excelbanter.com/excel-worksheet-functions/245047-add-space-between-numbers.html)

hema

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

Jacob Skaria

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

Ashish Mathur[_2_]

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

All times are GMT +1. The time now is 10:47 PM.