Do you want to use Excel along with Jira but wondering how to connect them together?
#YourComments #ExcelVBA #RESTAPI
Learn Jira REST API, here is my free course.
Let us say you have a some sentences in your excel sheet in one or two cells. Now if you are very particular about punctuation like me then you may want to change the case of all the words starting in a sentence. Let us say you have some sentences like below in various cells.
My second job with Kaplan Financial (earlier know as eMind) I worked mainly for Product Support and later as Project Coordinator where I was doing really interesting stuff.
Today I was working on excel (yeah yeah I do work sometimes), I wanted to extract the first 20 characters from the string. I forgot the function name, I did a quick google search and found out the solutions.
My friend Vinod gave me a problem to change the background color of entire row to Red and also to change the font to bold. It seems to be an easy task but there are two constraints.
1. He want to do this only for those lines which has font color of red.
Want to contact me?
Want my help? raise a support request for me.
Social and other Links
- RSS Feed
- @ravisagar on Twitter
- Ravi Sagar YouTube: Atlassian tools and Jira tutorials
- Ravi Sagar LBRY: Synced with Ravi Sagar YouTube
- Blackberry Boy YouTube: Linux, Emacs, Org Mode and tech tutorials
- Ravi Sagar Podcast
- @ravisagar.in on Instagram
- Ravi.pro: site published with Org Mode, general IT and tech stuff
- LinuxIndya.com: site published with Org Mode on Linux
- AutoGrid.info: site published with Org Mode on Excel VBA and Google Apps Script