how to copy first 2 characters only from prior cell

's Computer Specifications

I need to take the string of characters from one cell and split it into 3
separate cells. Is there a formula that can accomplish this?

's Computer Specifications

You could use data>text to columns>fixed
or
=left(a1,2)
or mid(a1,1,2)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"jsm1th" <(E-Mail Removed)> wrote in message
news:810630C1-7CF7-4652-AE56-(E-Mail Removed)...
>I need to take the string of characters from one cell and split it into 3
> separate cells. Is there a formula that can accomplish this?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I copy more than 255 characters in a cell without truncati	Gary Grung	Microsoft Excel Misc	1	13th Feb 2009 05:46 PM
How do I copy more than 255 characters per cell?	=?Utf-8?B?SlI=?=	Microsoft Excel Misc	2	20th Jun 2007 08:40 PM
Copy all but last 9 characters of a cell	=?Utf-8?B?QmVu?=	Microsoft Excel Misc	4	30th May 2007 08:04 PM
How to copy the cell contains above 255 characters from one sheet.	=?Utf-8?B?U2VudGhpbA==?=	Microsoft Excel Misc	1	8th Aug 2006 04:48 AM
enter formula to copy characters in a cell less last one	=?Utf-8?B?QkNARA==?=	Microsoft Excel Misc	1	5th Apr 2006 11:19 PM