Posted to microsoft.public.excel.programming

Chad[_3_]

external usenet poster

Posts: 32

Copying part of a string to another cell

Hi All,

Is there an easy way to do this?
I want to copy the first 6 characters from [A1] to [K1], [A2]..[K2] all the
way to last row.

I am assuming I will have to use a loop and use the Left command. I was
just hoping for an easier way since it is the entire column.

Chad

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying part of a cell	David	Excel Discussion (Misc queries)	3	December 29th 09 08:46 PM
Search/Match/Find ANY part of string to ANY part of Cell Value	TWhizTom	Excel Worksheet Functions	0	July 21st 08 08:16 PM
copying part of a number string	Bill R	Excel Discussion (Misc queries)	1	February 12th 06 10:38 PM
Move Part of Cell String	tom[_7_]	Excel Programming	8	October 13th 05 06:37 PM
select part of a cell value string	rich_j_h	Excel Discussion (Misc queries)	2	May 19th 05 11:36 AM

All times are GMT +1. The time now is 08:08 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us