Alter Text in 900 cell entries

's Computer Specifications

I need to change text from "A" to "B" as shown below in about 900 cell
entries in excel 2000 ver (9.0.8961 SP-3) Suggestions please!!!

A: 21071303129W300
B: 21/07-13-031-29W3/0
--
raywood

's Computer Specifications

Hi

The ingredients for the solution are LEFT, RIGHT, MID and the & (the
concatenation operator)

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music

"raywood" wrote:

> I need to change text from "A" to "B" as shown below in about 900 cell
> entries in excel 2000 ver (9.0.8961 SP-3) Suggestions please!!!
>
> A: 21071303129W300
> B: 21/07-13-031-29W3/0
> --
> raywood

's Computer Specifications

To be specific ;-)

=LEFT(A1,2)&"/"&MID(A1,3,2)&"-"&MID(A1,5,2)&"-"&MID(A1,7,3)&"-"&MID(A1,10,4)&"/"&RIGHT(A1)

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music

"Wigi" wrote:

> Hi
>
> The ingredients for the solution are LEFT, RIGHT, MID and the & (the
> concatenation operator)
>
>
> --
> Wigi
> http://www.wimgielis.be = Excel/VBA, soccer and music
>
>
> "raywood" wrote:
>
> > I need to change text from "A" to "B" as shown below in about 900 cell
> > entries in excel 2000 ver (9.0.8961 SP-3) Suggestions please!!!
> >
> > A: 21071303129W300
> > B: 21/07-13-031-29W3/0
> > --
> > raywood

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I switch the order of text entries in a cell?	=?Utf-8?B?dHJhaW5lcjA3?=	Microsoft Excel Misc	3	17th May 2007 03:05 AM
Alter Duplicate Product ID Entries	=?Utf-8?B?TWlrZQ==?=	Microsoft Excel Worksheet Functions	3	20th Oct 2006 06:50 PM
how to alter cell format if cell contains text	=?Utf-8?B?SGVhdGhlciBhdCBXRU8=?=	Microsoft Excel Worksheet Functions	4	28th Jul 2005 07:18 PM
How to alter text inside a table cell using Javascript	Trevor L.	Microsoft Frontpage	8	17th Feb 2005 03:18 AM
Alter one cell value, in case another cell's value changed	=?Utf-8?B?bXlCYXNpYw==?=	Microsoft Excel Programming	5	19th May 2004 07:44 PM