| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
to replace only the last text/chracter in a cell
to replace only the last text/chracter in a cell
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to replace only the last text/chracter in a cell
I'm not clear what you're asking but let me take a shot at an answer. If you
have text in A2 and you want the last character to be replaced by what's in B2 and the result put in C2, you could put the following in C2: =left(A2,len(A2)-1) & B2 Will "Petee" wrote: to replace only the last text/chracter in a cell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| REPLACE PART OF CELL WITH FORMATTED TEXT | Excel Worksheet Functions | |||
| How do I change replace text in a cell for different text? | Excel Worksheet Functions | |||
| How do I seacrh for the chracter "*" without it being a wildcard. | Excel Discussion (Misc queries) | |||
| Append Text to Cell Values Using Replace | Excel Discussion (Misc queries) | |||
| Replace ALT+ENTER from multiple text cell | Excel Discussion (Misc queries) | |||
Linear Mode
