Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
EXCEL - Want to split cell value where comma occurs
Hi Skip -- Most excellent! It worked. Thanks! Cheers, Sophy- sophy
- Post #3
- Forum: Microsoft: Office
-
EXCEL - Want to split cell value where comma occurs
Hi all -- I have an Excel spreadsheet which has a field called "names" which has lastname, firstname in it. I'd like to separate out the last name into a cell and the firstname into a separate cell. They are separated by a comma. I can't for the life of me figure out the command for this...- sophy
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
Number format won't keep when doing mail merge
Duane!!! It worked!!!! Thank you! Thank you! Thank you! Cheers, S- sophy
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Number format won't keep when doing mail merge
Hi all -- I am running a simple query with a purchase price field which I use to mail merge into a Word document. I've got my purchase price field in the table AND query as a currency format, BUT, when it merges into Word, it comes out as plain old "2500" rather than "2,500.00". Is there an...- sophy
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Q - line getting cut in half at bottom of report page
THANK YOU! That worked! I had it set to CanGrow but not CanShrink. Cheers, Sophy- sophy
- Post #3
- Forum: Microsoft: Access Reports
-
Q - line getting cut in half at bottom of report page
Hi all -- I have a very plain jane, vanilla report that simply grabs fields from my query and then prints them. No fancy groupings, etc. For some reason, every once in awhile, the last sentence on a page will appear with only the top part of the sentence showing and the bottom part will show...- sophy
- Thread
- Replies: 3
- Forum: Microsoft: Access Reports
-
return last change date in a cell
Thanks all! I used the macro and it worked like a dream.- sophy
- Post #4
- Forum: Microsoft: Office
-
return last change date in a cell
Hi all -- I am wondering if it is possible to return the last change date to a worksheet in a cell in that worksheet. Thanks! Cheers.- sophy
- Thread
- Replies: 3
- Forum: Microsoft: Office
