Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
formula
Hi,
I have a problem. I have in column A a system tag 202.E.0716/LN114-01. I want another column to automatically give me 202E0716LN11401. I have more than 1000 points in my list and I dont want to manually type the all the points. Thanks in advance. Yem |
#2
|
|||
|
|||
If you only have to get rid of the dots and dashes, you could use a formula
like: =SUBSTITUTE(SUBSTITUTE(A1,".",""),"-","") Yem wrote: Hi, I have a problem. I have in column A a system tag 202.E.0716/LN114-01. I want another column to automatically give me 202E0716LN11401. I have more than 1000 points in my list and I dont want to manually type the all the points. Thanks in advance. Yem -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |