If I have "123456789" in a cell I wish to copy specifc parts of it to other
cells
i.e.
A1 first 3 - 123
A2 second 3 - 456
A3 third 3 - 789
How can I do this both in a worksheet and using VBA.
Thanks
Jo

In a work sheet

=left($A$1,3) (123)
=mid($A$1,4,3) (456)
=right($A$1,3) (789)

VBA is the same layout, just minus the "="

Left( Range( "A1" ).Value , 3)
Mid( Range( "A1" ).Value , 4 , 3)
Right( Range( "A1" ).Value , 3)


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=276435

Assuming "123456789" in b1
=left(b1,3) in a1
=mid(b1,4,3) in a2
=right(b1,3) in a3

Lance

"Jo" wrote:

If I have "123456789" in a cell I wish to copy specifc parts of it to other
cells
i.e.
A1 first 3 - 123
A2 second 3 - 456
A3 third 3 - 789
How can I do this both in a worksheet and using VBA.
Thanks
Jo