Re: create simple macro

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You need to be a bit more specific. There doesn't seem to be a pattern here.

--
Don Guillett
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"noraisens" <noraisens.232x6y_1139685303.8615@xxxxxxxxxxxxxxxxxxxxx> wrote
in message news:noraisens.232x6y_1139685303.8615@xxxxxxxxxxxxxxxxxxxxxxxx

I have one column of 500 numbers similar to this "cc03052" they all
start with cc I need the macro to add "05" into the number at a
specific point then to go the next.

before after
cc03052 cc0305052
cc04130 cc0412050

can anyone help me


--
noraisens
------------------------------------------------------------------------
noraisens's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=31450
View this thread: http://www.excelforum.com/showthread.php?threadid=511382



.

Relevant Pages

  • Re: problem with printing from cs4
    ... One detail still doesn't fit the pattern: ... correctly when you let the printer driver handle the color profile. ... and i paid $700 5 months ago for new heads ....which of course are now ...
    (alt.graphics.photoshop)
  • Re: how to count specific item???
    ... Don Guillett ... Howdy all, ... I have a column that contains a specific number in each cell, ... Jeff32's Profile: ...
    (microsoft.public.excel.misc)
  • Re: How would you make this pull?
    ... Draw out the profile as if it's sitting on a table top and you're ... Duplicate the pattern ... numerous times (I'd just draw it out on my computer and print it). ... direction, tape the two pieces back together, and then do the cut along ...
    (rec.woodworking)
  • Re: How to use a LEFT function in an IF Macro Comparison
    ... Sub colorrowsif' NO selections ... Don Guillett ... .Pattern = xlSolid ...
    (microsoft.public.excel.programming)
  • Re: Macro Error Help
    ... "Don Guillett" wrote: ... .Pattern = xlSolid ...
    (microsoft.public.excel.misc)