| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace data to right of string problem
Hi,
you can also try: =SUBSTITUTE(A1,MID(A1,LEN(A1)-4,4),"XXXX") Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace string | Excel Programming | |||
| Chartspace Data Source and Connection String Problem | Excel Programming | |||
| Replace Hyperlink Addresses Help 'Dim OldStr As String, NewStr As String | Excel Programming | |||
| How do I replace last numeric string from a alphanumeric string? | Excel Discussion (Misc queries) | |||
| Problem with search and replace data,thanks for you help in advance. | Excel Discussion (Misc queries) | |||
Threaded Mode
