please help me link cells that have numbers and letters

  • Thread starter Thread starter thuma1004
  • Start date Start date
T

thuma1004

Can anyone help me learn how I can type a stock number on sheet 1 in m
workbook that contains both letters and numbers and have i
automatically show up in a dedicated cell on sheet 2. I can do thi
with numbers only, but I heard it can be done. Any help on this matte
is greatly appriciated
 
Hi
not really sure what you're trying to do. What formula do you use for
numeric values?
 
In dedicated cell on sheet2 enter =Sheet1!A1

Whatever you type or enter in Sheet1A1 will be returned in Sheet2

Or are you looking for something else?

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change all text on Spread sheet 1
Information from one sheet to another help please. 1
Excel Sum numbers in cells that also contain text 34
Find the first letter in a cell 5
cells containing text and numbers 5
Count if based on criteria within cells on another sheet 1
HELP NEEDED!! Link cells between worksheets 2
How do I Designating a number with letters? 8

Back
Top