BettyAtKitchen

Senior Member

Last Activity: 08-Nov-2009 10:46 AM

Visitor Messages

IMPORTANT! READ THIS FIRST!
This form is to write a personal message to another user. DO NOT ASK FOR TECH SUPPORT HERE. To ask your tech support question, please go to the forums or read our welcome guide for new members. Thanks for your cooperation!

Showing Visitor Messages 1 to 6 of 6

05-Mar-2009 01:10 PM
BettyAtKitchen

Hi.. I have a database of companies with their addresses. How can the data be separated into street address, town, state and zip WHEN the data are all on column A, like this:

Stephen Inc
123 West Ave, Millady, NY 10000
Billy LLC
456 North Lane, Wellsby, NY 11577
Ron Co.
789 Broadway, New Lake, NY 10101
05-Sep-2008 01:18 PM
BettyAtKitchen

ok.. i will post a new thread and will wait for your reply. tnx
05-Sep-2008 01:15 PM
computerman29642

If you could, create a thread with a sample file attached.
- View Conversation
05-Sep-2008 01:06 PM
computerman29642

I will be more than happy to try.
- View Conversation
08-Jul-2008 04:07 PM
BettyAtKitchen

Concatenate Help

I need to merge contents of two cell. I have been using Concatenate. However, in this particular case, one column has dollar values and the other column has unit item... .such when the two columns are merged, it should look like this:

Price Per Unit
9.00 case -->9.00/case
9.80 case -->9.80/case
9.99 case -->9.99/case

however, the merge will drop the zero if there is no other number to the right of it.

my question is: how should the merge be done so that the zeros are kept after the merge. thanks.
04-Jun-2008 03:37 PM
BettyAtKitchen

I wonder what I did... I have been using Excel 2007. When I use formulas, Excel automatically calculates for me. Now, when I type, for example, "=2*25" then hit enter, nothing happens.

Any suggestion?