Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a formula that delete first character and adds another
I need a formula that deletes and add:
Example: change 127-0112 to X27-0112 delete first character and replace with "X" or replace first character with "X" Tracey Harold |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a formula that delete first character and adds another
A1 =127-0112
Try the formula in B1 ="X" & MID(A1,2,LEN(A1)) If this post helps click Yes --------------- Jacob Skaria "Tracey" wrote: I need a formula that deletes and add: Example: change 127-0112 to X27-0112 delete first character and replace with "X" or replace first character with "X" Tracey Harold |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a formula that delete first character and adds another
On Tue, 11 Aug 2009 10:34:01 -0700, Tracey
wrote: I need a formula that deletes and add: Example: change 127-0112 to X27-0112 delete first character and replace with "X" or replace first character with "X" Tracey Harold =REPLACE(A1,1,1,"X") --ron |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a formula that delete first character and adds another
You said you "need a formula", so I presume the responses Ron and Jacob gave
you answer you question. However, you did post your question in a programming newsgroup, so on the off chance you were really looking for a VB solution... Range("A1").Value = "X" & Mid(Range("A1").Value, 2) -- Rick (MVP - Excel) "Tracey" wrote in message ... I need a formula that deletes and add: Example: change 127-0112 to X27-0112 delete first character and replace with "X" or replace first character with "X" Tracey Harold |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is the formula that identifies v8 in a row & adds v8+v8=v16? | Excel Discussion (Misc queries) | |||
How to set up a formula that it adds value on a certain date | Excel Discussion (Misc queries) | |||
NEED A FORMULA THAT ADDS EVEN OR ODD ROW NUMBERS | Excel Worksheet Functions | |||
Formula which adds together worksheets | Excel Discussion (Misc queries) | |||
Exporting adds a character | Excel Discussion (Misc queries) |