Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Insert Cell Data Into String
I am trying to insert data from cells into a new cell. I am working on a contacts list, and I want the email address to display like this:
[RFAX:NAME@/FN=FAXNUMBER] WITH 'NAME' BEING EXTRACTED FROM CELL B2 AND 'FAXNUMBER' BEING EXTRACTED FROM CELL AA2. CAN ANYBODY HELP? |
#2
|
|||
|
|||
Quote:
To put it another way, does B2 contain only the name or is there other info with it? Does cell AA2 contain only the fax number or is there other info with it? |
#3
|
|||
|
|||
Quote:
=concatenate(B2,"@",AA2) This will combine B2 with AA2 and place the @ symbol between them with no spaces. Hope this helps. TD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A string of data in a cell | Excel Worksheet Functions | |||
Extracting Data from a string of text in a cell | Excel Worksheet Functions | |||
String of data in a cell. Want to use 'contains' in an 'if' statem | Excel Discussion (Misc queries) | |||
IN AN IF FORMULA COPY STRING OF DATA IF A CELL IS CORRECT | Setting up and Configuration of Excel | |||
Need macro to insert text string while inside cell (formula) | Excel Discussion (Misc queries) |