Dear Experts:

I would like to extract the substring located between the 8th and the 9th underscore from the right, i.e. 90-235-58-22

I got a user-defined function for that, but I also would like to have a formula. Hope this is feasible!

G:\KLS_Allgemein\DMD\PM_2_3\IFU_Bos_Driver_90-235-58-22_REV_2_RD_2016-02_5s_SF_S24_bw.pdf

Help is much appreciated. Thank you very much in advance.

Regards, Andreas

I am trying to migrate off of Lync server 2010 to Skype for Business server 2015.  I have created a new server have patched the server all the way with the windows updates and then started my Skype for Business install.  I was running through the Skype for Business Server 2015 Deployment Wizard.  I have already prepared AD with no issues and then moved onto Install or Update Skype for Business Server System.  However it did not detect one of the prerequisites which is KB2982006.  I have tried installing it and I keep getting "The update is not applicable to your computer"  I have tried installing all of the prerequisites for this file but cannot install one prerequisites that it needs which is KB2919442.  It gives me the same error.  I have done a sfc /scannow with no errors, tried windows update troubleshooter with no luck.  Any suggestions.

Hi

I need to create an Excel CSV file.  This CSV file has a column of large numbers .....  example 2100000000003   .

I wish for the numbers to be represented in full view.   I need to see the full number so that I know that each number is unique.
 Excel insists on changing the  number to scientific notation.  Of course, they all look the same then.

The application accepting this CSV file will read the numbers as text,

Question... How do I save the CSV file so that I open it again,  I will see the full number instead of the scientific notation representation.

Thank you.

Hi Experts!

I want to adjust the width of the all the columns from C2 up to the last column
these are my code

Dim LastColumn As Long
LastColumn = ActiveSheet.UsedRange.Columns(ActiveSheet.UsedRange.Columns.Count).Column
Columns("C2", LastColumn).EntireColumn.AutoFit

My problem is
  A.   I have a run -time error on this part
  Columns("C2", LastColumn).EntireColumn.AutoFit
  B.   I have a group cells and I want it to remain it group as I autofit all the cells

Hi,

I am making a Pivot table. I have three columns - Title, CTC, and Medical.

On showing Title in Row section of Pivot, I want to show CTC, then Medical, and then Medical as PerCent of CTC.
How :)

Attached file for reference.

Thanks,
San.
Pivot---PerCent-of-Parent-Column.xlsx

Dear Experts:

I got the following file paths entered in column A

M:\KLS_General\DMD\PM_1\MyFile_Final_2.pdf
M:\KLS_General_17\DMD\PM_2_3\MyFile2.pdf
M:\KLS_General_2\DMD\PM_4_5_6\MyFile6_Final_23072017.pdf

Is it possible to extract the substrings after the fourth (4th) back slash using a formula. I got a macro for this purpose but I wonder whether the same could be achieved using a formula, ie. applying the formula the results would be as follows:

MyFile_Final_2.pdf
MyFile2.pdf
MyFile6_Final_23072017.pdf

Help is much appreciated.

Thank you very much in advance.

Regards, Andreas

Can you please help me regarding all the cells?
What I want is To highlight cell form range ("C7" to the last row )

this is my code

Dim LastRow
LastRow = ActiveSheet.UsedRange.Rows.Count
    Dim x As Range
' How can I declare a range  from the Range ("C6 up to the last row of KHL") not just 50
    Set x = Worksheets("Product").Range("C6:KHL50").Cells
    Dim sRange As Range
How can I declare a range  from the Range ("A6 up to the last row of B") not just 100
    Set sRange = Range("A6:B100")
    Application.ScreenUpdating = False
    With ActiveCell
        If InRange(ActiveCell, sRange) Then
          MsgBox ("Cannot Mark This Area")
        Else
        ' Highlight the entire sheets that contain the active cell
          x.Interior.Color = RGB(255, 255, 0)
          sRange.Interior.ColorIndex = xlNone
       End If
    End With
  Application.ScreenUpdating = True

Hi all,
we are currently running windows 7 x64, 95% of user computers have HP Elitebook laptops (850 users across few different countries), have anyone done project plan for a windows 10 upgrade? what issues were faced and whats there to avoid or take into account?

will rollout window 10 and office 2016 as a package.

SharePoint Online Question -   Regarding auto resizing of images, ppt and videos in SPO.     I currently have embedded videos, PowerPoint decks and images in a site.   What needs to be done to enable these to auto "resize" when the size/resolution is changed?

Ms Project 2010 crashing on windows 7 enterprise.  how to fix this?  reimage didn't help.

from application event viewer:


Unexpected or missing value (name: 'PackageName', value: '') in key 'HKLM\Software\Classes\Installer\Products\C313169CB933B504A9B878815848CEDA\SourceList'

Unexpected or missing value (name: 'PackageName', value: '') in key 'HKLM\Software\Classes\Installer\Products\A1A2502679901BE4D91D71F6A2A203B2\SourceList'

Faulting process id: 0x504
Faulting application start time: 0x01d30f8cdf069df9 Faulting application path: C:\Program Files (x86)\Microsoft Office\Office14\WINPROJ.EXE Faulting module path: C:\Program Files (x86)\Microsoft Office\Office14\WINPROJ.EXE Report Id: 286b3f04-7b80-11e7-8ba1-e09d31314280

Faulting application name: WINPROJ.EXE, version: 14.0.4751.1000, time stamp: 0x4b8e2648 Faulting module name: WINPROJ.EXE, version: 14.0.4751.1000, time stamp: 0x4b8e2648 Exception code: 0xc0000005 Fault offset: 0x004a1b22 Faulting process id: 0x11bc Faulting application start time: 0x01d30f8c5c1ab14d Faulting application path: C:\Program Files (x86)\Microsoft Office\Office14\WINPROJ.EXE Faulting module path: C:\Program Files (x86)\Microsoft Office\Office14\WINPROJ.EXE Report Id: c2c8ddf3-7b7f-11e7-8ba1-e09d31314280

I did setup DFS replication between two folders from two servers. After a week, I created diagnostic report and there were no errors and there were no backlogged files on both servers.
Then I went and compared those two folders in size, file/folder numbers. They all matched.
Then I dismantled the replication by deleting the replication group.
When I checked DfsrPrivate folder, there were so many files in staging folder.
What are they? Are they going to be disappeared or do I need to delete them manually?

We need to extract a table from a PDF document into Excel and clean it up by moving columns around and deleting unnecessary rows, and then paste the results into a new Word file. This task is done several times weekly, so we would like to create a macro to automate the task.

Details:

1. The number of columns in Excel, and their position in the table may vary, but the column headings that we need are always named the same.

1. The Excel table will always reside in Sheet2.

Macro steps;

1. Move Column called IDENT to right of Column called NAME

1. Move Column called TYPE to right of Column called IDENT

1. Move Column called LATITUDE to right of Column called TYPE

1. Move Column called LONGITUDE to right of Column called LATITUDE

1. Remove all remaining columns to right of LONGITUDE that contain data

1. Under Column B (NAME) find first row with "-" in cell, and delete this entire row and all subsequent entire rows to last row containing any data

1. Copy the table, and then paste `as text only`, into a new Word file

I have attached a sample of the Excel table pre-cleanup.

Thanks!
Andrea
EE_Table_Cleanup.xlsx

Hi

I am using Microsoft word 2013 and typing in English language. When I copy lyrics  from a website which is in a different language (to the same document). I get ???????? rather than the actual lyrics .
Please let me know how to resolve this. Are there any settings that I need to enable. Any help would be great.

Thanks