Home > IT Answers > Microsoft Windows > Use of the EXCEL formula function to copy data and insert an asterik on both ends of output.
Tmdillon
5 pts.
 Use of the EXCEL formula function to copy data and insert an asterik on both ends of output.
Excel 2003, Excel formulas, Microsoft Excel
Is there a method to use the formula function to copy the contents entered in one cell (A2)into cell B2 with the addition of an asterisk '*' on both ends of the copied text? An example being - Enter 'H123456' in A2, with the output in B2 being '*H123456*'

Software/Hardware used:
ASKED: November 26, 2008  4:27 PM
UPDATED: November 26, 2008  5:20 PM
RELATED QUESTIONS
Answer Wiki:
Hi, Try this :- =CONCATENATE("*";A2;"*") Regards, Martin Gilbert. ================== or ==("*"&A2&"*")
Last Wiki Answer Submitted:  November 26, 2008  5:20 pm  by  Gilly400   23,625 pts.
All Answer Wiki Contributors:  Gilly400   23,625 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _