Neal,
Excel's macro language is not a keystroke language. The macro recorder will
record whatever data you leave the cell with -- it doesn't care how you did
it.
For your situation, if you want it split in half, you could put a formula in
col's B anc C:
=LEFT(A2, 4) =RIGHT(A2, 4)
To convert the formulas to actual data, copy columns B and C, then do Paste
Special - Values (right over them). now you don't need the original stuff
in Column A any more.
If you splilt the data on something other than 4 characters, tell us what
the criteria is, and we'll go from there.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
"Neal Zimm" wrote in message
...
I need a work around to the following situation.
I'm editing a lot of cells to split the data into two cells and there is a
pattern, but Excel is picking up 'keystrokes' I don't want. aaaa is always
a
4 digit number, and bbbb is various text.
Befo
cell 1 cell 2
aaaa bbbb
Desired After:
cell 1 cell 2
aaaa bbbb
I recorded a relative macro, and I get the desired result the first time,
BUT, not the second.
Example:
Befo
cell 1 cell 2
aaaa bbbb
Desired After:
cell 1 cell 2
aaaa bbbb this one works.
next set of two cells, befo
cell 1 cell 2
cccc dddd
After Actual when macro is run:
cell 1 cell 2
aaaa bbbb
even tho' the macro is relative, Excel is obviously remembering the
value's
aaaa and bbbb on subsequent cells; this I do NOT want.
Help? Thanks.
--
Neal Z
|