Search : in
By :

Custom CELL Address to Field Value

Last answer on Sep 15, 2009 10:47:14 am BST jwuj97f, on May 14, 2009 1:30:39 pm BST 
 Report this message to moderators

Hello,
does anyone know how to convert a custom Cell Address to its field value in Excel?

I used Concatenate command to create Cell Address i.e.
=CONCATENATE("=","C",C3)

got the following string
=C28

How can I convert / see the content of C28? I need to know how to convert the string value into its field value.

Thanks

Configuration: Windows XP
Firefox 3.0.10

Best answers for « Custom CELL Address to Field Value » in :
Can vba return excel cell value with formats Show
Excel - Send value of cell to target Show Excel - Send value of cell to target Issue Solution Note Issue Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value changes to '0'? My...
Send value of cell to target (Solved) Show
E-mail Address Not Verified Show[E-mail Address Not Verified] is displayed next to the username Introduction Configure your email address so that it works on MSN Messenger Introduction When you use MSN Messenger or Windows Live Messenger with an address not...
[VBA] Deleting a word in a range of cell Show[VBA] Deleting a word in a range of cell In the case you want to delete a word in a sentence, just create a small macro that removes the word. But it will become difficult when you have word like, for example, "Theword" or "THEWORD" or...
Repainting a cell using excel VBA ShowRepainting a cell using excel VBA Issue Solution Note Issue I am writing a code in excel VBA to generate a report.I am totally new to VBA.Here's my code Private Sub CommandButton1_Click() Dim a1 As Integer Dim d1 As Integer Dim...
Download Custom Addressbook ShowDescription The application is designed by FreeByte Soft. Custom AddressBook is an application that enables you to define your fields and categories. Simple and easy to use, the application has been awarded from various places. Offering an intuitive...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
NAT- Network address translation, port forwarding and port trigg ShowThe principle of NAT Network address translation or NAT was developed in order to respond to the shortage of IP addresses with IPv4 protocol (in time the IPv6 protocol will respond to this problem). In fact, in IPv4 addressing the number of...
Ask your question Reply

1

Excelguru, on May 15, 2009 4:14:53 am BST
  • +1

Use =INDIRECT("C" & C3) Winners are losers who got up and gave it one more try. -Dennis DeYoung

   
Reply to Excelguru

2

jwuj97f, on May 16, 2009 5:52:05 am BST

Thanks, the INDIRECT worked perfectly!

Again, Thanks,

   
Reply to jwuj97f

3

 belo, on Sep 15, 2009 10:47:14 am BST

Hello i have dhe dd cell and mm cell and yyyy cells and i want to unit them in one cell in format dd/mm/yyyy how can i do in

   
Reply to belo
Ask your question Reply
They need your help