Adding a space within a cells value
 

I am trying to input a space within a cell, and then copy the task all
the way down the column for all the cells in that column. So each
cells value will change as follows.

G8599999
G7944444
G8155555

becomes

G85 99999
G79 44444
G81 55555

Is there a Macro I can use to accomplish this. I have tried to have
the Macro recorder record it however it just replaces each cell with
the same value that I recorded. I have also found some other
explanations of such a macro, however I could not understand them, so
any basic explanation of the code would be much appreciated. Thank you
very much for any help that can be provided.

-Keith

Adding a space within a cells value
 

How about inserting an adjacent column and using a formula:

=left(a1,3)&" "&mid(a1,4,len(a1))
or
=if(a1="","",left(a1,3)&" "&mid(a1,4,len(a1)))

Then drag down the column.
Edit|Copy
edit|paste special|Values over the original range
and delete the helper column.


NewUser22 wrote:

I am trying to input a space within a cell, and then copy the task all
the way down the column for all the cells in that column. So each
cells value will change as follows.

G8599999
G7944444
G8155555

becomes

G85 99999
G79 44444
G81 55555

Is there a Macro I can use to accomplish this. I have tried to have
the Macro recorder record it however it just replaces each cell with
the same value that I recorded. I have also found some other
explanations of such a macro, however I could not understand them, so
any basic explanation of the code would be much appreciated. Thank you
very much for any help that can be provided.

-Keith

--

Dave Peterson

Adding a space within a cells value
 

On Jul 10, 5:13 pm, Dave Peterson wrote:
How about inserting an adjacent column and using a formula:

=left(a1,3)&" "&mid(a1,4,len(a1))
or
=if(a1="","",left(a1,3)&" "&mid(a1,4,len(a1)))

Then drag down the column.
Edit|Copy
edit|paste special|Values over the original range
and delete the helper column.





NewUser22 wrote:

I am trying to input a space within a cell, and then copy the task all
the way down the column for all the cells in that column. So each
cells value will change as follows.

G8599999
G7944444
G8155555

becomes

G85 99999
G79 44444
G81 55555

Is there a Macro I can use to accomplish this. I have tried to have
the Macro recorder record it however it just replaces each cell with
the same value that I recorded. I have also found some other
explanations of such a macro, however I could not understand them, so
any basic explanation of the code would be much appreciated. Thank you
very much for any help that can be provided.

-Keith

--

Dave Peterson- Hide quoted text -

- Show quoted text -

Thanks,

That did it perfectly.