Home |
Search |
Today's Posts |
#1
|
|||
|
|||
special characters
Hello,
Is there an excel function to reference another cell that only pulls in characters, values or words that are not a specific value, for example "UD". Ex. Cell A1 Cell B1 (formula) 12,345 UD 12,345 |
#2
|
|||
|
|||
One way:
=SUBSTITUTE(A1," UD","") In article , tjh wrote: Hello, Is there an excel function to reference another cell that only pulls in characters, values or words that are not a specific value, for example "UD". Ex. Cell A1 Cell B1 (formula) 12,345 UD 12,345 |
#3
|
|||
|
|||
=--LEFT(a1,FIND(" ",a1))
"tjh" wrote: Hello, Is there an excel function to reference another cell that only pulls in characters, values or words that are not a specific value, for example "UD". Ex. Cell A1 Cell B1 (formula) 12,345 UD 12,345 |
#4
|
|||
|
|||
To return a number as opposed to text
=--SUBSTITUTE(A1," UD","") -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "tjh" wrote in message ... Hello, Is there an excel function to reference another cell that only pulls in characters, values or words that are not a specific value, for example "UD". Ex. Cell A1 Cell B1 (formula) 12,345 UD 12,345 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Special Characters on Labels | Excel Discussion (Misc queries) | |||
excel data label format special number characters (part 2) | Excel Discussion (Misc queries) | |||
REMOVE SPECIAL CHARACTERS FROM TEXT CELLS | Excel Worksheet Functions | |||
Special Characters in Headers and Footers | Excel Discussion (Misc queries) | |||
Special characters | Excel Worksheet Functions |