custom format cell with text and numbers
Thanks to all.
--
maryj
"Dave F" wrote:
Well, you could use a formula if AA111122223 never changes the number of
characters.
Assume AA111122223 is in A1.
=concatenate(left(a1,2),"-",mid(a1,4,4),"-",mid(a1,7,4),"-",right(A1,1))
Dave
--
Brevity is the soul of wit.
"maryj" wrote:
Client needs to change existing values from AA111122223 to AA-1111-2222-3. Is
there any way to do this with custom formatting? Or what other options might
there be? Thanks!
--
maryj
|