Solved

Modify data in a cell in Excel

Posted on 2013-01-24
4
295 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 33

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 17

Author Closing Comment

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

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

734 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