Ask your question
Message list Discussion Forum list

Adding text

MAK - Jun 17, 2009 12:03pm BST - Last answer on Jun 27, 2009 1:16pm BST Excelguru
Report
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 & regardsConfiguration: Windows XP Internet Explorer 7.0
Read more ...

More answers for :
Adding text »

I have an answer
Add comment

Kioskea recommends you to read :

How to eneter values from user form to excelForumProgramming
To put files into apple iphoneForumWindows
Inserting text in a fileTipsSed
Importing csv file data in Excel with VBAForumOffice software
Excel formula to get the cell with the text [Solved]ForumOffice software
Creating an ad hoc WiFi networkReviewsNetwork configuration
Sort by :   Votes | Date | Date descending 3 answers
+0
moins plus
Excelguru 268Posts April 11, 2009Registration date Jun 17, 2009 12:19pm BST
Hi MAK
use =A1 & "Text" and = "Text" & A1

Add comment - Permalink (1)
Add comment
+0
moins plus
MAK Jun 20, 2009 6:50am BST
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 ??

 Add comment - Permalink (2)
Add comment
+0
moins plus
Excelguru 268Posts April 11, 2009Registration date Jun 27, 2009 1:16pm BST
Hi MAK
After applying the formula, copy it and then 'paste special'>>values

Add comment - Permalink (3)
Add comment
Top
See also
supinfo