A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How do I enter the same data no multiple cells with current data?



 
 
Thread Tools Display Modes
  #1  
Old July 10th 07, 10:12 PM posted to microsoft.public.excel.worksheet.functions
Maggie
external usenet poster
 
Posts: 35
Default How do I enter the same data no multiple cells with current data?

Please help.
Ads
  #2  
Old July 10th 07, 10:34 PM posted to microsoft.public.excel.worksheet.functions
Wigi
external usenet poster
 
Posts: 396
Default How do I enter the same data no multiple cells with current data?

Maggie

Don't put your question in the title.

In addition, be more specific, in order to get a good response.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Maggie" wrote:

> Please help.

  #3  
Old July 10th 07, 10:42 PM posted to microsoft.public.excel.worksheet.functions
Maggie
external usenet poster
 
Posts: 35
Default How do I enter the same data no multiple cells with current data?

I'll be a bit more specific. I want to know if there is a way of adding the
same data to multiple cells that already have data without changing the
existing data in the cell. For example if I have a number 07165489 I want to
be able to add to the front of it 978. I want to do the same thing to
multiple cells

Thank you.

"Maggie" wrote:

> Please help.

  #4  
Old July 10th 07, 10:56 PM posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_2_]
external usenet poster
 
Posts: 563
Default How do I enter the same data no multiple cells with current da

If this these are real numbers - you need to do an arithmetic operation on
them-
enter 97800000000 in an empty cell; copy it; select the cells of interest;
use Edit > Paste Special with Add checked; deete the cell with 97800000000

If the 'numbers' are things like account 'numbers': use formula
=TEXT("978","###")&TEXT(A1,"#######"); copy down the column next to the cell
of interest; now use Copy followed by Edit > Paste Special with Values
checked to convert fromulas to values. Now you can delete the original values.

best wsihes
--
www.stfx.ca/people/bliengme


"Maggie" wrote:

> I'll be a bit more specific. I want to know if there is a way of adding the
> same data to multiple cells that already have data without changing the
> existing data in the cell. For example if I have a number 07165489 I want to
> be able to add to the front of it 978. I want to do the same thing to
> multiple cells
>
> Thank you.
>
> "Maggie" wrote:
>
> > Please help.

  #5  
Old July 10th 07, 11:10 PM posted to microsoft.public.excel.worksheet.functions
Maggie
external usenet poster
 
Posts: 35
Default How do I enter the same data no multiple cells with current da

THANK YOU! This worked perfectly.
You just made my day

"Bernard Liengme" wrote:

> If this these are real numbers - you need to do an arithmetic operation on
> them-
> enter 97800000000 in an empty cell; copy it; select the cells of interest;
> use Edit > Paste Special with Add checked; deete the cell with 97800000000
>
> If the 'numbers' are things like account 'numbers': use formula
> =TEXT("978","###")&TEXT(A1,"#######"); copy down the column next to the cell
> of interest; now use Copy followed by Edit > Paste Special with Values
> checked to convert fromulas to values. Now you can delete the original values.
>
> best wsihes
> --
> www.stfx.ca/people/bliengme
>
>
> "Maggie" wrote:
>
> > I'll be a bit more specific. I want to know if there is a way of adding the
> > same data to multiple cells that already have data without changing the
> > existing data in the cell. For example if I have a number 07165489 I want to
> > be able to add to the front of it 978. I want to do the same thing to
> > multiple cells
> >
> > Thank you.
> >
> > "Maggie" wrote:
> >
> > > Please help.

  #6  
Old July 11th 07, 12:46 AM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 22,911
Default How do I enter the same data no multiple cells with current data?

First, 07165489 is not a number unless you have formatted to 00000000

Otherwise it is text.

Couple of ways.

1. in a helper column celll enter ="978" & A1. Copy down the column.

2. With a macro to change all in place at one go with no formulas.

Post back if 2. would suit you.


Gord Dibben MS Excel MVP

On Tue, 10 Jul 2007 14:42:01 -0700, Maggie >
wrote:

>I'll be a bit more specific. I want to know if there is a way of adding the
>same data to multiple cells that already have data without changing the
>existing data in the cell. For example if I have a number 07165489 I want to
>be able to add to the front of it 978. I want to do the same thing to
>multiple cells
>
>Thank you.
>
>"Maggie" wrote:
>
>> Please help.


  #7  
Old July 11th 07, 03:28 AM posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
 
Posts: 3,718
Default How do I enter the same data no multiple cells with current data?

Select your ranges > Edit > Replace > Find what: 07165489 > Replace with:
97807165489

"Maggie" wrote:

> Please help.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
enter data once... copy to multiple cells on other worksheets Larry G Excel Discussion (Misc queries) 4 January 3rd 07 07:13 PM
How can I enter data into multiple worksheets at once in Excel? YMCAyouthsports Excel Discussion (Misc queries) 2 October 10th 06 08:39 PM
Linked Cells not displaying most current data hcamelion Excel Discussion (Misc queries) 2 August 2nd 06 09:44 PM
how do i enter data in multiple sheets simultaneously Usman Satti Excel Worksheet Functions 2 March 15th 06 02:47 PM
enter data into multiple formulas at once Fen Excel Worksheet Functions 1 October 18th 05 05:39 PM


All times are GMT +1. The time now is 02:04 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.