Sppidsolution

Keeping bang your head against a brick wall, you will be a talent.

Home

Home

Friday 19 September 2014

Insert diameter into line tage number

Basic formular:

Most convinient formular:
=SUBSTITUTE(A1,"-","-"&B1&"-",3)

Posted by ----------------Sppidsolution at 11:46

Email This BlogThis!Share to Twitter Share to Facebook Share to Pinterest

Labels: Excel skill

Newer Post Older Post Home

Language Translator

SPPID Resources

Intergraph SPPID
SPPID Forum

About Me

----------------Sppidsolution: Calgary, Alberta, Canada; Mechanical Engineer,Science bachelor, 23 years work experience. work on process PID since 2005 in Oilsands Industry. Master on SmartPlant(SPPID).

View my complete profile

Blog Archive

▼ 2014 (3)
- ► November (1)
- ▼ September (1)
  - Insert diameter into line tage number
- ► July (1)

► 2013 (9)
- ► November (1)
- ► September (1)
- ► July (1)
- ► March (1)
- ► February (2)
- ► January (3)

► 2012 (28)
- ► December (1)
- ► November (3)
- ► September (2)
- ► June (2)
- ► May (11)
- ► April (4)
- ► March (2)
- ► January (3)

► 2011 (33)
- ► December (2)
- ► October (1)
- ► September (2)
- ► August (4)
- ► July (20)
- ► June (3)
- ► May (1)

Labels

Dos Command
Excel skill
Internet knowledge
Microstation
Oracle
Others
SPPID Solution
SPPID Training

Popular Posts

Intergraph SmartPlant P&ID User Tips and Tricks

I always be asked about what is the difference between AutoCAD and SmartPlant P&ID. I try my best to give an answer, which is always not...
SPPID_How to covert SPPID to MicroStation or AutoCAD

1. Click file, and then save as. 2. Click save as type, there’re several choice include Micro Station and AutoCAD.
SPPID_Training lesson 5_How to make a Display Filter

1. Click View, apply Display Set.
SPPID_Can not break the line between two nozzles

In order to put the Heat Tracing segment break in the middle of two nozzles. We need break the line between two nozzles. Most of times, we c...
SPPID_Training Lesson 6_How to use stockpile

1. Re-use OPC. As "SPPID_Can not do and Can do" mentioned: UN-needed OPC should be deleted into stockpile. How to re-used OPC? ...
SPPID_How to put instrumentation text and Tag sequence no.

Some drafters just simply type text into instrumentation symbol. It's not correct. The first letter ( Measured Variable Code ) and Tag ...
How to become a SPPID User_Courses need to take

As a SmartPlant P&ID user, basicly, you need take the following course: 1. Piping drafting certificate of Achievement at SAIT...
SPPID_How to change OPC Connector to another drawing

1. Open the current connection drawing.(right click, then click “Open Continuation Drawing.
SPPID_How to compare two difference version drawings

1.Open drawing manager. 2. right click the drawing, then "Revisions"- "Version History". 3. select any 2...
SPPID_Relationship Repair (between graphic and database)

Sometimes, a window shows that graphic is disconncected with database. If you ignore it, there will always be strange trouble with this draw...

Simple theme. Theme images by luoman. Powered by Blogger.