| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
replace part text in a cell
How can I replace the 7th item in each cell of the examples below to say 5?
30-02220.900.LAU should be changed to say 30-02250.900.LAU 40-02430.000.FIN should be changed to say 40-02450.000.FIN 10-02210.520.005 should be changed to say 10-02240.510.004 Many thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
replace part text in a cell
On 8 Dec., 03:47, Indra wrote:
How can I replace the 7th item in each cell of the examples below to say 5? 30-02220.900.LAU should be changed to say 30-02250.900.LAU 40-02430.000.FIN should be changed to say 40-02450.000.FIN 10-02210.520.005 should be changed to say 10-02240.510.004 Many thanks! Try this: =LEFT(A1,6) & 5 & MID(A1,8,LEN(A1)-7) Regards, Per |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
replace part text in a cell
On Sun, 7 Dec 2008 18:47:01 -0800, Indra
wrote: How can I replace the 7th item in each cell of the examples below to say 5? 30-02220.900.LAU should be changed to say 30-02250.900.LAU 40-02430.000.FIN should be changed to say 40-02450.000.FIN 10-02210.520.005 should be changed to say 10-02240.510.004 Many thanks! =REPLACE(A1,7,1,5) will do it but your third example appears to be incorrect -- you have replaced the 7th character "1" with a "4" --ron |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
replace part text in a cell
Or more directly...
=REPLACE(A1,7,1,5) -- Rick (MVP - Excel) "Per Jessen" wrote in message ... On 8 Dec., 03:47, Indra wrote: How can I replace the 7th item in each cell of the examples below to say 5? 30-02220.900.LAU should be changed to say 30-02250.900.LAU 40-02430.000.FIN should be changed to say 40-02450.000.FIN 10-02210.520.005 should be changed to say 10-02240.510.004 Many thanks! Try this: =LEFT(A1,6) & 5 & MID(A1,8,LEN(A1)-7) Regards, Per |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
| find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
| REPLACE PART OF CELL WITH FORMATTED TEXT | Excel Worksheet Functions | |||
| Find and replace part of a text string | Excel Discussion (Misc queries) | |||
| Replace part of link address in a cell with a value(date) from ano | Excel Discussion (Misc queries) | |||
Linear Mode
