| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Alter Text in 900 cell entries
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Alter Text in 900 cell entries
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I switch the order of text entries in a cell? | Excel Discussion (Misc queries) | |||
| Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
| Alter Duplicate Product ID Entries | Excel Worksheet Functions | |||
| how to alter cell format if cell contains text | Excel Worksheet Functions | |||
| How can I alter the size of the text box in an Excel | Charts and Charting in Excel | |||
Linear Mode
