Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by jentc001
at 2024-08-09 04:47:56
ModifyPoint:500 Replies:4 POST_ID:828725USER_ID:11627
Topic:
Microsoft Excel Spreadsheet Software;;Microsoft Office Suite
Hi,
I'm looking to to use defined column values as a variable within a string in excel, without having to specify each variable in column b.
Columns
a b
john Please contact 'a1'@excel.com
bob Please contact 'a2'@excel.com
dan Please contact 'a3'@excel.com
How do i define this in excel and also add the variable in the middle of a string?
I'm looking to to use defined column values as a variable within a string in excel, without having to specify each variable in column b.
Columns
a b
john Please contact 'a1'@excel.com
bob Please contact 'a2'@excel.com
dan Please contact 'a3'@excel.com
How do i define this in excel and also add the variable in the middle of a string?
Author: jentc001 replied at 2024-08-09 06:35:25
Thanks Armchair_scouse! Spot on!
Expert: duncanb7 replied at 2024-08-09 04:56:15
I think so armchari_scours is correct to what you wants, otherwise please write it clearly
Accepted Solution
Expert: armchair_scouse replied at 2024-08-09 04:50:24
500 points EXCELLENT
In cell B1, enter ="Please contact " & A1 & "@excel.com" and follow this pattern on the other rows
Expert: duncanb7 replied at 2024-08-09 04:49:55
What is output you want at column B
