Adding text

Closed
MAK - Jun 17, 2009 at 07:03 AM
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
- Jun 27, 2009 at 08:16 AM
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

Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jun 17, 2009 at 07:19 AM
Hi MAK
use =A1 & "Text" and = "Text" & A1
0
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 ??
0
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jun 27, 2009 at 08:16 AM
Hi MAK
After applying the formula, copy it and then 'paste special'>>values
0