| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help, I need to add words to each row
Hello,
I have a worksheet that has several hundred rows and in 1 column I want to add 2 words before the text that is already in the rows in this column. For example, if in column A row 1-400 I have in each row a differnt line of text i.e. the day is long the night is short a dog is cool a cat is ok Now I want to add the 2 words "I think" in front of every row of text so it should look like I think the day is long I think the night is short I think a dog is cool I think a cat is ok Hope I explained it ok Thanks in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help, I need to add words to each row
Hi
If you data is in column A type this in column B and drag down to 400 ="I Think"&" "&A1 HTH John "Nobody" wrote in message ... Hello, I have a worksheet that has several hundred rows and in 1 column I want to add 2 words before the text that is already in the rows in this column. For example, if in column A row 1-400 I have in each row a differnt line of text i.e. the day is long the night is short a dog is cool a cat is ok Now I want to add the 2 words "I think" in front of every row of text so it should look like I think the day is long I think the night is short I think a dog is cool I think a cat is ok Hope I explained it ok Thanks in advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help, I need to add words to each row
Hi,
In cell B1, use the following formula ="I think "&A1 and copy down. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Nobody" wrote in message ... Hello, I have a worksheet that has several hundred rows and in 1 column I want to add 2 words before the text that is already in the rows in this column. For example, if in column A row 1-400 I have in each row a differnt line of text i.e. the day is long the night is short a dog is cool a cat is ok Now I want to add the 2 words "I think" in front of every row of text so it should look like I think the day is long I think the night is short I think a dog is cool I think a cat is ok Hope I explained it ok Thanks in advance |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help, I need to add words to each row
OK I guess I should have been more specific, I currently have data in
columns a,b,c it is column "C" that I want to add the " I think" to every row in column "C" Sorry I didn't give you the exact situation Thanks "Ashish Mathur" wrote in message ... Hi, In cell B1, use the following formula ="I think "&A1 and copy down. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Nobody" wrote in message ... Hello, I have a worksheet that has several hundred rows and in 1 column I want to add 2 words before the text that is already in the rows in this column. For example, if in column A row 1-400 I have in each row a differnt line of text i.e. the day is long the night is short a dog is cool a cat is ok Now I want to add the 2 words "I think" in front of every row of text so it should look like I think the day is long I think the night is short I think a dog is cool I think a cat is ok Hope I explained it ok Thanks in advance |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help, I need to add words to each row
All you need to do is change the reference from A1 to C1 or any cell number you
like. HTH John "Nobody" wrote in message ... OK I guess I should have been more specific, I currently have data in columns a,b,c it is column "C" that I want to add the " I think" to every row in column "C" Sorry I didn't give you the exact situation Thanks "Ashish Mathur" wrote in message ... Hi, In cell B1, use the following formula ="I think "&A1 and copy down. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Nobody" wrote in message ... Hello, I have a worksheet that has several hundred rows and in 1 column I want to add 2 words before the text that is already in the rows in this column. For example, if in column A row 1-400 I have in each row a differnt line of text i.e. the day is long the night is short a dog is cool a cat is ok Now I want to add the 2 words "I think" in front of every row of text so it should look like I think the day is long I think the night is short I think a dog is cool I think a cat is ok Hope I explained it ok Thanks in advance |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help, I need to add words to each row
Thank you,
It worked kinda, it did insert the "I Think" in front of the text already in the column BUT when I click on the cells instead of getting the text with "I think" in front of it I get the below in the fx bar space. I need every cell to have the actual text not fomulas in them ="I Think"&" "&C2 ="I Think"&" "&C3 ="I Think"&" "&C4 ="I Think"&" "&C5 "John" wrote in message ... All you need to do is change the reference from A1 to C1 or any cell number you like. HTH John "Nobody" wrote in message ... OK I guess I should have been more specific, I currently have data in columns a,b,c it is column "C" that I want to add the " I think" to every row in column "C" Sorry I didn't give you the exact situation Thanks "Ashish Mathur" wrote in message ... Hi, In cell B1, use the following formula ="I think "&A1 and copy down. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Nobody" wrote in message ... Hello, I have a worksheet that has several hundred rows and in 1 column I want to add 2 words before the text that is already in the rows in this column. For example, if in column A row 1-400 I have in each row a differnt line of text i.e. the day is long the night is short a dog is cool a cat is ok Now I want to add the 2 words "I think" in front of every row of text so it should look like I think the day is long I think the night is short I think a dog is cool I think a cat is ok Hope I explained it ok Thanks in advance |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help, I need to add words to each row
Hi Again
Once you got all the information, select all, copy, then go to Edit Paste Special select Values. This will replace the formula with your Text. You can paste in the column C to replace with the new phrase. Don't forget to save after. HTH John "Nobody" wrote in message ... Thank you, It worked kinda, it did insert the "I Think" in front of the text already in the column BUT when I click on the cells instead of getting the text with "I think" in front of it I get the below in the fx bar space. I need every cell to have the actual text not fomulas in them ="I Think"&" "&C2 ="I Think"&" "&C3 ="I Think"&" "&C4 ="I Think"&" "&C5 "John" wrote in message ... All you need to do is change the reference from A1 to C1 or any cell number you like. HTH John "Nobody" wrote in message ... OK I guess I should have been more specific, I currently have data in columns a,b,c it is column "C" that I want to add the " I think" to every row in column "C" Sorry I didn't give you the exact situation Thanks "Ashish Mathur" wrote in message ... Hi, In cell B1, use the following formula ="I think "&A1 and copy down. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Nobody" wrote in message ... Hello, I have a worksheet that has several hundred rows and in 1 column I want to add 2 words before the text that is already in the rows in this column. For example, if in column A row 1-400 I have in each row a differnt line of text i.e. the day is long the night is short a dog is cool a cat is ok Now I want to add the 2 words "I think" in front of every row of text so it should look like I think the day is long I think the night is short I think a dog is cool I think a cat is ok Hope I explained it ok Thanks in advance |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help, I need to add words to each row
Just in case.
When I said "Select All ", I mean select all the cells that have the formula only. HTH John "Nobody" wrote in message ... Thank you, It worked kinda, it did insert the "I Think" in front of the text already in the column BUT when I click on the cells instead of getting the text with "I think" in front of it I get the below in the fx bar space. I need every cell to have the actual text not fomulas in them ="I Think"&" "&C2 ="I Think"&" "&C3 ="I Think"&" "&C4 ="I Think"&" "&C5 "John" wrote in message ... All you need to do is change the reference from A1 to C1 or any cell number you like. HTH John "Nobody" wrote in message ... OK I guess I should have been more specific, I currently have data in columns a,b,c it is column "C" that I want to add the " I think" to every row in column "C" Sorry I didn't give you the exact situation Thanks "Ashish Mathur" wrote in message ... Hi, In cell B1, use the following formula ="I think "&A1 and copy down. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Nobody" wrote in message ... Hello, I have a worksheet that has several hundred rows and in 1 column I want to add 2 words before the text that is already in the rows in this column. For example, if in column A row 1-400 I have in each row a differnt line of text i.e. the day is long the night is short a dog is cool a cat is ok Now I want to add the 2 words "I think" in front of every row of text so it should look like I think the day is long I think the night is short I think a dog is cool I think a cat is ok Hope I explained it ok Thanks in advance |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help, I need to add words to each row
John,
Thanks so much that worked perfectly !!!!!!!! you saved me hours of work Thank you again "John" wrote in message ... Just in case. When I said "Select All ", I mean select all the cells that have the formula only. HTH John "Nobody" wrote in message ... Thank you, It worked kinda, it did insert the "I Think" in front of the text already in the column BUT when I click on the cells instead of getting the text with "I think" in front of it I get the below in the fx bar space. I need every cell to have the actual text not fomulas in them ="I Think"&" "&C2 ="I Think"&" "&C3 ="I Think"&" "&C4 ="I Think"&" "&C5 "John" wrote in message ... All you need to do is change the reference from A1 to C1 or any cell number you like. HTH John "Nobody" wrote in message ... OK I guess I should have been more specific, I currently have data in columns a,b,c it is column "C" that I want to add the " I think" to every row in column "C" Sorry I didn't give you the exact situation Thanks "Ashish Mathur" wrote in message ... Hi, In cell B1, use the following formula ="I think "&A1 and copy down. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Nobody" wrote in message ... Hello, I have a worksheet that has several hundred rows and in 1 column I want to add 2 words before the text that is already in the rows in this column. For example, if in column A row 1-400 I have in each row a differnt line of text i.e. the day is long the night is short a dog is cool a cat is ok Now I want to add the 2 words "I think" in front of every row of text so it should look like I think the day is long I think the night is short I think a dog is cool I think a cat is ok Hope I explained it ok Thanks in advance |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help, I need to add words to each row
Hi
You're welcome anytime. Regards John "Nobody" wrote in message ... John, Thanks so much that worked perfectly !!!!!!!! you saved me hours of work Thank you again "John" wrote in message ... Just in case. When I said "Select All ", I mean select all the cells that have the formula only. HTH John "Nobody" wrote in message ... Thank you, It worked kinda, it did insert the "I Think" in front of the text already in the column BUT when I click on the cells instead of getting the text with "I think" in front of it I get the below in the fx bar space. I need every cell to have the actual text not fomulas in them ="I Think"&" "&C2 ="I Think"&" "&C3 ="I Think"&" "&C4 ="I Think"&" "&C5 "John" wrote in message ... All you need to do is change the reference from A1 to C1 or any cell number you like. HTH John "Nobody" wrote in message ... OK I guess I should have been more specific, I currently have data in columns a,b,c it is column "C" that I want to add the " I think" to every row in column "C" Sorry I didn't give you the exact situation Thanks "Ashish Mathur" wrote in message ... Hi, In cell B1, use the following formula ="I think "&A1 and copy down. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Nobody" wrote in message ... Hello, I have a worksheet that has several hundred rows and in 1 column I want to add 2 words before the text that is already in the rows in this column. For example, if in column A row 1-400 I have in each row a differnt line of text i.e. the day is long the night is short a dog is cool a cat is ok Now I want to add the 2 words "I think" in front of every row of text so it should look like I think the day is long I think the night is short I think a dog is cool I think a cat is ok Hope I explained it ok Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Say it in words | Excel Discussion (Misc queries) | |||
| in words | Excel Worksheet Functions | |||
| how to convert numeric to words Example 525 in words (Twenty five | Excel Discussion (Misc queries) | |||
| how do i insert words into a column without erasing the words | Excel Discussion (Misc queries) | |||
| more words | New Users to Excel | |||
![Nobody[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
