#1
|
|||
|
|||
Excel formula for labeling on both end of a cable
Dear folk Attached template I am using Excel find to make labels for cables at their both ends not only one end Cell E14 I have got this : ' TO KEREM PDP' In cell E18 if I want word 'TO' to be removed means : ' KEREM PDP' What formula needs to be used ? Thx |
#2
|
|||
|
|||
.
Paste in E18 : Code:
=RIGHT(E14,9) |
#3
|
|||
|
|||
Thx for your help
What about G11, G21 How can I add 'TO' to G21 by using formula ? |
#4
|
|||
|
|||
="to" & g11
|
#5
|
|||
|
|||
Noted
Thx for that |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Formula | breen77 | Excel | 7 | 08-01-2018 07:29 AM |
Labeling Subsections Automatically | mohsen.amiri | Word | 7 | 06-19-2017 09:24 AM |
Cable management | adminstefan | Visio | 1 | 02-13-2017 08:48 AM |
Excel formula help please! | dreamer1963 | Excel | 2 | 03-16-2014 03:59 AM |
Labeling sequential forms with a unique number | krau0231 | Word | 1 | 10-18-2012 03:33 PM |