Solved

Add character to colum of numbers in Excel 2007

Posted on 2011-09-25
1
190 Views
Last Modified: 2012-05-12
I have a column of numbers in Excel 2007.
I need to add " before and after every number. Eg change 123456 to "123456"

There are several hundred numbers to add this too.
0
Comment
Question by:Mayogroup
1 Comment
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 total points
ID: 36596650
Hello,

try

=""""&A1&""""

copy down. Then copy the result and Paste Special > Values over the original data.

cheers, teylyn
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
.Range Set 25 78
EXCEL 2013 question. 4 28
Change date stored as "short text" YYYYMMDD to MM/DD/YYYY? 27 28
macro modification Column C 14 31
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

778 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