Thread: adding spaces
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default adding spaces

Put this into cell A1 ab123456789us
Maybe this. Put into cell B1
=MID(A1,1,2)& " "&MID(A1,3,3)& " "&MID(A1,6,3)& " "&MID(A1,9,3)& "
"&MID(A1,12,2)

"John K" wrote:

I have a cell that I want to say put in ab123456789us, but have it look like
ab 123 456 789 us. Is there away to do that?