Threads by Jaffey
-
- Title
- Replies
- Last Reply
-
-
-
modify UDF function to insert a comma every 79 chars instead of every 2 chars 2
- Jaffey
April 29, 2013 at 9:11 PM - Excel General
- Jaffey
April 29, 2013 at 9:54 PM
-
- Replies
- 2
- Views
- 1.3k
2
-
-
-
-
transpose rows to combination of rows and columns 15
- Jaffey
April 29, 2013 at 4:07 PM - Excel General
- Jaffey
May 4, 2013 at 4:37 PM
-
- Replies
- 15
- Views
- 4.6k
15
-
-
-
-
modify text splitting function to work with rows instead of columns 4
- Jaffey
April 27, 2013 at 6:22 PM - Excel General
- Jaffey
April 28, 2013 at 3:16 PM
-
- Replies
- 4
- Views
- 2.1k
4
-
-
-
-
combine 24,000 text files and append filename details to each record 12
- Jaffey
April 24, 2013 at 3:57 AM - Excel General
- Jaffey
April 26, 2013 at 3:16 PM
-
- Replies
- 12
- Views
- 4.7k
12
-
-
-
-
only select visible cells during loop 2
- Jaffey
April 17, 2013 at 9:40 PM - Excel General
- Jaffey
April 17, 2013 at 9:59 PM
-
- Replies
- 2
- Views
- 1.2k
2
-
-
-
-
Add 2 hours to every date/time result in a column of data 4
- Jaffey
January 18, 2013 at 3:41 PM - Excel General
- Jaffey
January 18, 2013 at 6:20 PM
-
- Replies
- 4
- Views
- 1.9k
4
-
-
-
-
delete string before last colon if no text after last colon 2
- Jaffey
November 28, 2012 at 5:23 PM - Excel General
- Jaffey
November 28, 2012 at 8:12 PM
-
- Replies
- 2
- Views
- 1.9k
2
-
-
-
-
modify Advanced Filter code to specify criteria range on different worksheet 2
- Jaffey
November 25, 2012 at 8:20 PM - Excel General
- Jaffey
November 26, 2012 at 3:24 PM
-
- Replies
- 2
- Views
- 3k
2
-
-
-
-
insert new row for each line of text contained in a single cell and copy account# 2
- Jaffey
November 7, 2012 at 5:00 PM - Excel General
- Jaffey
November 7, 2012 at 6:25 PM
-
- Replies
- 2
- Views
- 1.3k
2
-
-
-
-
run VBA/excel macros in non-Excel spreadsheet? 1
- Jaffey
August 11, 2012 at 6:37 PM - Excel General
- Jaffey
August 11, 2012 at 8:18 PM
-
- Replies
- 1
- Views
- 1.4k
1
-
-
-
-
delete X rows after every blank row not including the first non-blank row 2
- Jaffey
June 22, 2012 at 11:15 PM - Excel General
- Jaffey
June 23, 2012 at 5:09 PM
-
- Replies
- 2
- Views
- 1.5k
2
-
-
-
-
combine 1000's of csv files and append Lic#, filename and date to each row 5
- Jaffey
May 12, 2012 at 10:24 PM - Excel General
- Jaffey
May 14, 2012 at 10:54 PM
-
- Replies
- 5
- Views
- 4.2k
5
-
-
-
-
Hide Pivot Items by Keyword 4
- Jaffey
November 24, 2011 at 11:37 PM - Excel General
- Jaffey
November 25, 2011 at 2:52 PM
-
- Replies
- 4
- Views
- 2.7k
4
-
-
-
-
remove specific text and dates within a cell 5
- Jaffey
October 11, 2011 at 10:35 PM - Excel General
- Jaffey
October 12, 2011 at 4:09 PM
-
- Replies
- 5
- Views
- 2.3k
5
-
-
-
-
Remove Duplicate Rows 1
- Jaffey
July 20, 2011 at 8:13 PM - Excel General
- Jaffey
July 21, 2011 at 2:16 AM
-
- Replies
- 1
- Views
- 2k
1
-
-
-
-
split address into address/city/province/postal 5
- Jaffey
May 26, 2011 at 6:12 PM - Excel General
- Jaffey
May 27, 2011 at 2:55 AM
-
- Replies
- 5
- Views
- 4.7k
5
-
-
-
-
import multiple csv files with header record and addresses with carriage returns 5
- Jaffey
April 24, 2011 at 7:59 PM - Excel General
- Jaffey
April 24, 2011 at 10:07 PM
-
- Replies
- 5
- Views
- 4.4k
5
-
-
-
-
Import and parse csv files with extraneous commas? 3
- Jaffey
April 19, 2011 at 8:08 PM - Excel General
- Jaffey
April 20, 2011 at 6:26 AM
-
- Replies
- 3
- Views
- 2.4k
3
-
-
-
-
Reset agent's status on a master list while looping through daily refresh list 6
- Jaffey
February 20, 2011 at 11:21 PM - Excel General
- Jaffey
February 24, 2011 at 4:50 AM
-
- Replies
- 6
- Views
- 3.8k
6
-
-
-
-
Combine two macros and collate changes between new data and master list 10
- Jaffey
January 14, 2011 at 1:24 AM - Excel General
- Jaffey
January 18, 2011 at 3:58 AM
-
- Replies
- 10
- Views
- 5k
10
-