All Questions
6 questions
0
votes
1
answer
1k
views
using Python to retrieve formatted strings from excel cell
I'm trying to pull a string from an excel cell that will retain it's formatting when executed in Python. For example. I'm only a week into learning this (and this is my first post on stackoverflow), ...
0
votes
3
answers
7k
views
EXCEL - How to create a custom cell format for an Australian phone number: xxxx-xxx-xxx
Australian mobile phone (cell phone) and land line phone numbers are all 10 digit numbers which all begin with a zero.
When I enter the phone number into an Excel cell formatted as a Number it drops ...
- 113
0
votes
0
answers
11
views
Get all cell contents throughout file into a single cell [duplicate]
I have a CSV file will about 80 rows. Only the first column has data (email address)
I want to get all the email addresses, into a single cell, seperated by a comma.
For example:
1 Bob@microsoft....
- 1,203
3
votes
3
answers
26k
views
VLOOKUP is returning blank as 1/0/1990, rather than nothing visible
All cells are formatted for dates, when a cell is blank I would like it to return an apparently blank cell rather than 1/0/1900. Here is what I have so far however It is still returning the date ...
- 63
20
votes
4
answers
136k
views
Formatting a number to two digits even if the first is a 0 vba
I would like to be able to use VBA to display any number between 1-24 as a 2 digit number. Obviously the only ones that have a problem with this are 1-9 which I would like displayed as 01, 02, 03, etc....
- 1,222
2
votes
1
answer
48k
views
How do you format text/strings in VBA?
In the code below, I take some input parameters, either text or a cell, and combine them to form one string using the formatting I need. I need to make Task_Name bold, as well as text like "Lead :". ...
- 5,078