Each payment has a hyphen, followed by 4 digits. Can I do something with that? After each hyphen count 4 positions, then move it to a new cell or something?
Sorry, I should have explained further: Each group of payment info is in a cell, and each row is different:
So the first cell is:
OCF-1993 B & W-1989 UNR-1996 MANVILLE-1996 O-I-1998 FORTY-EIGHT INSULATION-1998 E-P1-2000 H.K. PORTER-2000 CELO-P1-2003 CELO-P2-2005
But another cell is...
Thanks so much! There's 2 columns I'm concerned with here, ColA has a unique identifying number: 123456
ColB has the fixed with data:
OCF-1993 B & W-1989 UNR-1996 MANVILLE-1996 O-I-1998 FORTY-EIGHT INSULATION-1998 E-P1-2000 H.K. PORTER-2000 CELO-P1-2003 CELO-P2-2005
I need to get...
Any help is greatly appreciated. I'm using Excel2003, and I inherited a spreadsheet with a column that has a large amount of fixed witdth data in it, in the format of "company-date".
But the companies vary in name and length, so when I try to use the text to columns wizard, I can't add...
Ok thanks! Here's what I set up on Friday:
The DID line is patched to an internal extension, so a regular phone rings, ext. 152
Then I set up a calling group, #772, and added the 2 people to it.
Then on the phone that rings, I just turned on forwarding to ext. 772.
This seems to work on...
Thanks everyone for the replies. I've got the calling group (772) all set up with 2 extensions in it. But How do I route the calls from the extension it's on now to the calling group #772?
Also, I tried *44, and *42 to log in to a group, but it doesn't work.
Thanks again!
Thanks again MM for your help. The release says:
Legend 7.0 v9.0
Again, what I'm trying to accomplish is 3 separate calling groups (hunt groups) that I can label as such, so the display can identify or distinguish the calls from eachother. However the people in the 3 different goups will be...
Thanks so much MM, you've always answered my posts!!
Quick question, and I probably should have mentioned this before: Our company actually answers calls for 3 others smaller companies. So the way I have it now (and you way seems better with the groups) is that each company we answer calls...
We're a small business (Merlin Magix system), there's 2 people who answer help calls. The calls come in on 1 extension, then the 1st person has a primary cover on the extension, and the 2nd person has the 2nd cover.
Is this the best method, or should I be setting up calling groups?
When I try...
Thanks guys! I'm doing it now, I'll let you know how it goes. But does a physical phone have to actually be plugged into a jack for this to work.
Here's what I'm really doing. We're companyA, and we do work for companies B and C. But we only have 1 "customer support" person. So I need her...
Not sure how to go about doing this. We have an Merlin Magix phone system here, and I'm trying to add a new extension internally. The internal extension is 151, but it's patched to the outside, so it should be a Direct dial line
When I call internally, ext 151 won't go anywhere. When I call...
Thanks again all, I know this is an old post.
On the caller ID: My extension line is patched directly to the outside, so it can be dialed directly, however when an incoming call comes in, the display just says "Incoming Call" or something like that (I think it says "outside call")
So if...
I have my data all grouped and sorted the way I want:
2 types of payments Payment_typeA, & Payment_typeB, grouped, then subgrouped by Date(quarterly).
When I view the data detail, it's correct, but I'm having trouble getting it into a stacked bar chart. For example, if the Count of...
Thanks for the reply, but I'm trying to get to the actual attachment in an email, through Crystal.
I found the attribute "Attachment" when connecting to an Exchange Mailbox, but when I add it to my report, it just returns True/False, not the actual attachment.
Thanks again!
CR10, I have a report on an shared Microsoft Outlook mailbox that gives some information such as FROM, TO, SUBJECT, etc. This works fine, but some of the emails have attachments, that I'd love for the user to be able to open directly from Crystal. The report designer lists all the components...
I'm not sure if I'm just missing the obvious here, but I have a pie chart that shows some data, and in the Chart Expert > Legend Options: I have it set to show the percent of each slice of the total, and it neatly sums each slice and 100% at the bottom.
Now, on the exact same data, I'm trying...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.