Google Answers Logo
View Question
 
Q: Excel Worksheet (using Excel for Mac 2004) question - ( No Answer,   2 Comments )
Question  
Subject: Excel Worksheet (using Excel for Mac 2004) question -
Category: Computers > Software
Asked by: mommia-ga
List Price: $2.00
Posted: 01 Nov 2006 10:42 PST
Expires: 01 Dec 2006 10:42 PST
Question ID: 779145
I am working o a simple excel file. In one column, labeled "product id
code". This column has either 2 or 3 digit numbers in it. I need to
add an 8 or 9 digit number to every cell in front of the existing
number. Is there an easy way of doing this? Basically I am trying to
add a bar code prefix to each product id number. I am adding the same
number each time (either 89489800 or 894890 depending on if it is a 2
or 3 digit number. ) Right now I am just pasting it into every cell
and it is taking a while to do.
Answer  
There is no answer at this time.

Comments  
Subject: Re: Excel Worksheet (using Excel for Mac 2004) question -
From: joet31124-ga on 01 Nov 2006 12:20 PST
 
If Product ID Code is in Column B and contains the 2 or 3 digit
number, then select cell C2 and type this formula (assuming that the
first number is in cell B2):
=IF(LEN(B2)=2,"89489800"&B2,IF(LEN(B2)=3,"894890"&B2,""))
You can then copy and paste this formula as far down the C column as
you want (or you can drag down on the little black spot at the lower
right corner of cell C2).
Subject: Re: Excel Worksheet (using Excel for Mac 2004) question -
From: agbinfo-ga on 05 Nov 2006 08:44 PST
 
Try this

If column A contains your data, enter this formula in column B
=A:A+8948980000

If you don't want to carry the formula, you can cut column B and
paste-special (values only) back to A then delete B.

Hope that helps,
- Alain

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy