Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 10th 07, 10:12 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 35
Default How do I enter the same data no multiple cells with current data?

Please help.

  #2   Report Post  
Old July 10th 07, 10:34 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
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   Report Post  
Old July 10th 07, 10:42 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
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   Report Post  
Old July 10th 07, 10:56 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
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   Report Post  
Old July 10th 07, 11:10 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
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   Report Post  
Old July 11th 07, 12:46 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
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   Report Post  
Old July 11th 07, 03:28 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 08:49 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017