Nel post
*brian* ha scritto:

i'm trying to figure out if there is any way to switch a column of 6
digit numbers so that the first 3 numbers are the last 3 and vise
versa. example.. 111222=222111, or 198321=321198. any help would be
welcomed. thanks for your time.


Hi Brian.

If you want a number to use in calculation use the formula:

=VALUE(RIGHT(A22,3)&LEFT(A22,3))

instead, if you need just a string, you can use the formula:

=RIGHT(A22,3)&LEFT(A22,3)


--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Ciao

Franz Verga from Italy