Tag Archives: Excel

Excel(r) create cell reference from Concatenated Text

Turning a Concatenated Text to a cell reference. Notes •Presentation of Creating a cell reference from a created Text •Excel ® used is a Microsoft product •Presentation app: Microsoft’s PowerPoint •Presentation shown to spark ideas of use. •This presentation is … Continue reading

Posted in Test Sector | Tagged , , , , , | Leave a comment

VBA Excel_All Upper Case to First Letter of word Upper Case

Presentation on VBA used to convert All Upper Case to First Letter of word Upper Case Notes •Presentation show use of “Proper” function in a Macro. Data in the A column and output on the C column in this example. … Continue reading

Posted in Test Sector | Tagged , , , , , | Leave a comment