Copy parts of cell - ExcelBanter

Posted to microsoft.public.excel.misc

Mike Mike

Posts: n/a

Copy parts of cell

I need to copy the first 8 characters from one cell to another like this:

lampshades
cheapcars
fluffybunny

will be

lampshad
cheapcar
fluffybu

Regards
Mike

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
need to Copy or Move to active cell from specified range	kaream	Excel Discussion (Misc queries)	2	December 14th 05 08:12 AM
How to Copy the value of a cell to any given cell	Memphis	Excel Discussion (Misc queries)	4	October 21st 05 08:29 PM
how to count the number of text frequencies and copy to other cell	DG	Excel Worksheet Functions	1	October 6th 05 07:11 PM
hpw do I logic test a cell then copy the row to diff. SS	Debi	Excel Worksheet Functions	4	October 5th 05 09:42 PM
How can I copy cell formats in functions?	Twitty Kitty	Excel Worksheet Functions	3	July 24th 05 12:26 AM

All times are GMT +1. The time now is 02:02 PM.

Menu

About Us