Related:
- If data in one column = A or B or C, then X
- Transfer data from one excel worksheet to another automatically - Guide
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
- How to be offline in whatsapp when data is on - Guide
- Data transmission cable - Guide
2 responses
sadgurl
Posts
697
Registration date
Thursday May 14, 2009
Status
Member
Last seen
November 24, 2010
219
Aug 31, 2009 at 11:43 AM
Aug 31, 2009 at 11:43 AM
You just want to remove the "comp-"
try that
dim strng as string
dim L as interger
strng = "Comp-Optical"
L = len(strng)
'Comp- make 5 characters '
strng =Right(strng, L- 5)
' at this point strng shoulf be "Optical" '
try that
dim strng as string
dim L as interger
strng = "Comp-Optical"
L = len(strng)
'Comp- make 5 characters '
strng =Right(strng, L- 5)
' at this point strng shoulf be "Optical" '
If you are less tech savy and want a non-coding option, use Text-to-Columns.
Highlight the column with full text names, then on the Data tab of Excel 2007 choose Text to Columns. Delimit by "-" then you will have a column with "Comp" and a column with anything after the "-". Then you can just delete the first column if you want.
Highlight the column with full text names, then on the Data tab of Excel 2007 choose Text to Columns. Delimit by "-" then you will have a column with "Comp" and a column with anything after the "-". Then you can just delete the first column if you want.
