View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mrmnz mrmnz is offline
external usenet poster
 
Posts: 14
Default Inserting a space between characters in a cell

Hi

I have a column of codes and some are written as below:

A2ABC
A2BBB
A2CBC
A2DBD

I want them all to has a space after the A2 ie. A2 ABC, A2 BBB etc etc.

What is the best/easiest way to do this?

Thanks.