Solved

Modify data in a cell in Excel

Posted on 2013-01-24
4
290 Views
Last Modified: 2013-01-24
I have a spreadsheet with ticket numbers from another team. I need to add INC to the left of the numbers.

For example if I have a number 0101999
I need it to look like INC0101999

Is there an automated way to add this?
0
Comment
Question by:Edward Pamias
4 Comments
 
LVL 24

Accepted Solution

by:
Steve earned 250 total points
ID: 38814893
Add a column then use formula:

= "INC"& A1

and copy down
0
 
LVL 13

Assisted Solution

by:Shanan212
Shanan212 earned 250 total points
ID: 38814896
You could insert a column next to the column with numbers (eg say the numbers are on column C2 and down) and then insert this formula

="INC"&C2

If you want to do it via VBA, can you post a sample?
0
 
LVL 32

Expert Comment

by:Rob Henson
ID: 38814914
Does the INC have to be actually in the cell value?

You could use a Custom Format:

"INC" 0

Select the required cells and apply the formatting using the usual cell formatting options, choose Custom.

Thanks
Rob H
0
 
LVL 15

Author Closing Comment

by:Edward Pamias
ID: 38814946
Thanks for the help guys!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SharePoint 2013 Link to File on Network Drive Not Working 3 23
Excel - Data Validation 3 28
Excel Question 17 15
Time difference between dates without weekend 16 25
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question