Excel Tips
My G/L Software Uses a Trailing Minus for Negative Numbers »
December 22, 2021
I have data where the minus sign appears after the number. Excel treats this as text.
Open CSV File With Dates in D/M/Y Format »
December 20, 2021
Our European subsidiary send me a CSV file. One of the columns is in DD/MM/YYYY format, but my international settings are expecting the dates in MM/DD/YYYY format.
Excel Is Randomly Parsing Pasted Data »
December 16, 2021
Every once in a while, I paste data from a text file to Excel, and Excel will spontaneously parse my data into several columns. I copied the names from the e-mail on the left, but when I pasted to Excel, the names appeared in one, two, or three columns. However, this may not happen tomorrow. It might happen only once every two weeks.
Parse Data using Text to Columns »
December 15, 2021
A vendor gave me a file that contains three-segment item numbers. The segments are separated by dashes. The FIND function makes my head hurt, but I need to break the part number into three columns. What do I do?
Break Data Apart Using Flash Fill »
December 14, 2021
Using LEFT, MID, RIGHT, FIND, and LEN makes my head hurt.
Join Text with a Date or Currency »
December 13, 2021
I just learned about concatenation, and I’m trying to join text with currency and with a date. As you can see in cell B13, when I attempt to join both date and currency with text, the currency loses the dollar sign and the date appears as a strange number. What am I doing wrong?
December 9, 2021
I have data with first names in column A and last names in column B. I want to merge these two columns into one column.
Add or Multiply Two Columns Without Using Formulas »
December 7, 2021
I’ve prepared a summary of sales by rep for the month. Due to an accounting glitch, someone gave me a similar file with additional sales made on the last day of the month. I need to add the new sales to the old sales. There is no need to keep the original two columns of partial month’s sales.