Adding text

[Closed]
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,
Do we have a formula? If I have a column of multiple rows and I want to add a text to all of the rows!
Example:
Column A the result would be column B and C
Mike Miketext textMike
Mark Marktext textMark
John johntext textJohn
Please, is there any book so that I can learn these formulas?
Thanks & regards

3 replies

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hi MAK
use =A1 & "Text" and = "Text" & A1
hello,
Dude but if we remove the Column A or if we copy the result to another cell we will lose the resulting text how we can save the resulting text as is it.
Example:
A:A b:B if we copy it to C:C
Mak = MAK & “text” MAK only ??
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hi MAK
After applying the formula, copy it and then 'paste special'>>values