selecting and copying part of cell content

This is a discussion on selecting and copying part of cell content within the Excel Questions forums, part of the Question Forums category; if i have a one cell A1 with content (for example) thelittlebrowndog, can anyone tell me how I can get ...

1. selecting and copying part of cell content

if i have a one cell A1 with content (for example) thelittlebrowndog, can anyone tell me how I can get 'little' to appear in cell A2, 'brown' to appear in cell A3 and dog to appear in cell A4.
'littlebrowndog' is just an example, as what I really want to do is to start in row one, get the first 3 characters of a cell to appear in th second column, next 5 characters to appear in column three etc, then to carry the process right down from row 1 to row 100.
Can anyone help?

2. Re: selecting and copying part of cell content

Originally Posted by MAC101
if i have a one cell A1 with content (for example) thelittlebrowndog, can anyone tell me how I can get 'little' to appear in cell A2, 'brown' to appear in cell A3 and dog to appear in cell A4.
'littlebrowndog' is just an example, as what I really want to do is to start in row one, get the first 3 characters of a cell to appear in th second column, next 5 characters to appear in column three etc, then to carry the process right down from row 1 to row 100.
Can anyone help?
Hi Mac101:

Welcome to the Board!

Let us say the entry in cell A1 is 11122222333 -- then to split it into 3 different strings as per your specification, use the following formulas ...

in B1 ... =LEFT(A1,3) ... that will give us 111
in C1 ... =MID(A1,4,5) ... that will give us 22222
in D1 ... =MID(A1,9,3) ... that will give us 333

then copy the formula in cells B1:D1 to B2:D2 through B100:D100

If you have a large number of such cells to convert, then a macro can be written to do the comversion with a single click of the button.

Does it help?

3. Thanks Yogi!

Yogi, the code you sent was exactly what I neede. Many thanks.

Mike :D

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•