Thread: Alter Text in 900 cell entries
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wigi Wigi is offline
external usenet poster
  
Posts: 396
Default Alter Text in 900 cell entries
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
Reply With QuoteReply With Quote