cell info

[Jo]

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

 

[kraljb]

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)

 

[LanceB]

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

Lance