Separating phone numbers

[SimonHughes]

Hello all, I have many telephone numbers in my CRM that are formatted as continuous numbers such as 01915671234 so when exported they come out as 1915671234. This happens as there are no spaces in the number so what I need to do is to format them as 0191 567 1234 - how do I get the spaces into these numbers? I am using MS365, many thanks in advance.

 

[etaf]

maybe a custom format of
0### ### ###0

Book21
	A	B
1	No format	Cell formatted custom
2	1915671234	0191 567 1234
Sheet1

 

[SimonHughes]

Hi etaf, that did the trick, all imported properly now. Thanks very much!

 

[etaf]

you are welcome