How do you add text into a field without deleting the content...

[DGK101]

Hi there

My problem that I have is that I have an excel spreadsheet with a few thousand rows, my column names are :name, cell number...

The content in the cell number column looks like this : 0753235504.
(the numbers are stored in that format) .
what i need to do is add a +27 to each cell number field in the spreadsheet so it should look like this +270753235504.(no spaces between the added +27 and the cell number)

How would i go about doing that???
if it were a few rows i could do it manually, but it is a few thousand rows... PLEASE HELP, it is going to take me forever!!!

 

[SkipVought]

DGK101,

You can do this in a multi step process.

Create a new column using the formula
[tt]
="+27"&A1
[/tt]
assuming that your source numbers are in Column A starting in Row 1.

copy the formula down thru your data

copy this column

select the source column and Edit/Paste Special - Values



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[DGK101]

@ Skip,

Thanks alot for your help, worked first time - i should really improve my knowledge of formulas - i strained myself trying to find a solution!!

thanks again...

DGK