Help!

how do i link cells that contain text in excel

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users RSS
Next:  Shortcut for current Time in hh:mm:ss  
Author Message
dumbone
External


Since: May 13, 2010
Posts: 1



PostPosted: Thu May 13, 2010 8:30 am    Post subject: how do i link cells that contain text in excel
Archived from groups: microsoft>public>excel>newusers (more info?)

i am creating a spreadsheet that will have several cells that contain the
same as another cell - either number or text - is there anyway to link so
when i type (example) the number 3 in cell A2 it will also appear in cells
C12 and D42. thanking everyone in advance for their assistance.
Back to top
Ms-Exl-Learner
External


Since: Sep 15, 2009
Posts: 14



PostPosted: Thu May 13, 2010 8:49 am    Post subject: RE: how do i link cells that contain text in excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

It can be done in 2 Methods.

Method 1:-
Place the cursor in C12 and press = and type A2. Now it will show the A2
cell value 3 in C12. if you place the cursor in C12 it will show the formula
as =A2. Follow the same step for D42 also.

Method 2:-
Place the cursor in C12 and press = and type INDIRECT(“A2”). Now it will
show the A2 cell value 3 in C12. if you place the cursor in C12 it will show
the formula as =INDIRECT(“A2”). Follow the same step for D42 also.

Advantage of Method 1:-
If you Cut and paste the A2 cell in any other location then the Method1 will
automatically change the C12 and D42 formula to the newly pasted cell
reference.

Advantage of Method2:-
If you Cut and paste the A2 cell in any other location then the Method2
won’t change the C12 and D42 formula to the newly pasted cell reference and
it will target only on A2 cell only.
--
Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"dumbone" wrote:

> i am creating a spreadsheet that will have several cells that contain the
> same as another cell - either number or text - is there anyway to link so
> when i type (example) the number 3 in cell A2 it will also appear in cells
> C12 and D42. thanking everyone in advance for their assistance.
Back to top
trip_to_tokyo
External


Since: Oct 03, 2009
Posts: 94



PostPosted: Thu May 13, 2010 8:52 am    Post subject: RE: how do i link cells that contain text in excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

EXCEL 2007

Just type:-

=A2

- into cells C12 and D42.

If my comments have helped please hit Yes.

Thanks.



"dumbone" wrote:

> i am creating a spreadsheet that will have several cells that contain the
> same as another cell - either number or text - is there anyway to link so
> when i type (example) the number 3 in cell A2 it will also appear in cells
> C12 and D42. thanking everyone in advance for their assistance.
Back to top
Eduardo
External


Since: May 04, 2006
Posts: 208



PostPosted: Thu May 13, 2010 9:14 am    Post subject: RE: how do i link cells that contain text in excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi,
In cells C12 and D42 enter

=A2



"dumbone" wrote:

> i am creating a spreadsheet that will have several cells that contain the
> same as another cell - either number or text - is there anyway to link so
> when i type (example) the number 3 in cell A2 it will also appear in cells
> C12 and D42. thanking everyone in advance for their assistance.
Back to top
szsjq



Joined: May 30, 2009
Posts: 101



PostPosted: Thu May 20, 2010 1:39 pm    Post subject: how do i link cells that contain text in excel [Login to view extended thread Info.]

Let's say you want to ensure that a column contains text and not numbers or you want to find all orders by a particular salesperson. There are several ways to check if a cell contains text but the case of the text doesn't matter to you.
What do you want to do?

Find cells that contain text

Filter a list for rows that contain specific text

Check if a cell has any text in it

Check if a cell matches specific text

Check if part of a cell matches specific text
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum