Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to add word to the front of every word in all rows automatica.
I had 1000+ words in all the rows and now I would like to add a symbol "\" to
the front of every words of all rows. Example: The initial word I had is "people" and now I would like to make it to "\people". All the rows contain of different words and I just want to add a slash in front of evey words. I would like to know how to make it. |
#2
|
|||
|
|||
Say your data is in column A.
Then insert a new column A and use a formula like: ="\"&a1 and drag down You can select that column and edit|copy edit|paste special|values and toss the original column if you want Jasmine wrote: I had 1000+ words in all the rows and now I would like to add a symbol "\" to the front of every words of all rows. Example: The initial word I had is "people" and now I would like to make it to "\people". All the rows contain of different words and I just want to add a slash in front of evey words. I would like to know how to make it. -- Dave Peterson |
#3
|
|||
|
|||
Hi Jasmine, this is how i would do it:
Assuming that your row of words are in row 1 then, copy ="\"&A1 in cell A2 then copy that cell across the rest of the row. Next select entire row 2 and copy it. Then select entire row 1 and right click on it and select special paste, then choose 'values'. Thats it, now you can deleted row 2and your done. "Jasmine" wrote: I had 1000+ words in all the rows and now I would like to add a symbol "\" to the front of every words of all rows. Example: The initial word I had is "people" and now I would like to make it to "\people". All the rows contain of different words and I just want to add a slash in front of evey words. I would like to know how to make it. |
#4
|
|||
|
|||
Jasmine Wrote: I had 1000+ words in all the rows and now I would like to add a symbol "\" to the front of every words of all rows. Example: The initial word I had is "people" and now I would like to make it to "\people". All the rows contain of different words and I just want to add a slash in front of evey words. I would like to know how to make it. Hi Jasmine Assuming your words to be in column A, in column B1 put the following formula =CONCATENATE(" ",A1), copy this formula down to the bottom of your list of words, quick way to do this is to move cursor to bottom right corner of B1 it will change to a black cross now double click it will copy the formula all the way down, next highlight column B and copy, paste special values to remove the formulas, finally do edit replace space with / Hope this helps Paul -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=474129 |
#5
|
|||
|
|||
Another way is to, in B1 (insert a blank column B if needed), use this formula: ="\"&A1 copy down per Paul's instructions. Then copy col. B, pastespecialvalues over col. A, delete col. B TIP: Always save your work BEFORE trying anything new.... Good Luck -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=474129 |
#6
|
|||
|
|||
Jasmine,
You could cause a backslash to appear in front of each cell like this: Select the cells. Format - Cells - Custom: "\"@ If you nave numbers instead of words in some cells, you might have to use: "\"General;"\"General;"\"General;"\"@ You can copy the code from here, and paste it into the Excel box. -- Earl Kiosterud www.smokeylake.com "Jasmine" wrote in message ... I had 1000+ words in all the rows and now I would like to add a symbol "\" to the front of every words of all rows. Example: The initial word I had is "people" and now I would like to make it to "\people". All the rows contain of different words and I just want to add a slash in front of evey words. I would like to know how to make it. |
#7
|
|||
|
|||
Hi! Earl: we need to be clear whether the OP wants the appearance of a \ or the reality of a \ (format or concatenate, in effect). I must say, I read it that s/he wanted concatenation, but it is ambiguous, I suppose. My bet is on concatenation... Alf -- AlfD ------------------------------------------------------------------------ AlfD's Profile: http://www.excelforum.com/member.php...fo&userid=4785 View this thread: http://www.excelforum.com/showthread...hreadid=474129 |
#8
|
|||
|
|||
Alf,
I agree. The concatenation solution may well be what the OP needs. It requires another cell to do the concatenation. The formatting solution puts the desired backslash in place, but might confound any formulas that have a reference to it, including some unexpected results, given Excel's penchant for surreptitious automatic cell formatting. Many posts don't give enough information to make the best choice, so most responders toss in any solution that hasn't been offered, as I did, and let the OP decide. -- Earl Kiosterud www.smokeylake.com "AlfD" wrote in message ... Hi! Earl: we need to be clear whether the OP wants the appearance of a \ or the reality of a \ (format or concatenate, in effect). I must say, I read it that s/he wanted concatenation, but it is ambiguous, I suppose. My bet is on concatenation... Alf -- AlfD ------------------------------------------------------------------------ AlfD's Profile: http://www.excelforum.com/member.php...fo&userid=4785 View this thread: http://www.excelforum.com/showthread...hreadid=474129 |
#9
|
|||
|
|||
I would have thrown in a macro solution into the brew for text constants:
insertpref macro in http://www.mvps.org/dmcritchie/excel/join.htm or PrefSuff macro in http://www.mvps.org/dmcritchie/excel/code/join.txt I didn't realize the subject disagrees with the post, but the body seems explicit to me. Concatenation doesn't care what you prefix. "Earl Kiosterud" wrote in message [clipped] Many posts don't give enough information to make the best choice, so most responders toss in any solution that hasn't been offered, as I did, and let the OP decide. "AlfD" wrote in Earl: we need to be clear whether the OP wants the appearance of a \ or the reality of a \ (format or concatenate, in effect). I must say, I read it that s/he wanted concatenation, but it is ambiguous, I suppose. My bet is on concatenation... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link excel to word so excel changes appear in word? | Excel Discussion (Misc queries) | |||
Can Excel Export Data to Word Format? | Excel Discussion (Misc queries) | |||
Entering Excel information into MS Word | Excel Discussion (Misc queries) | |||
How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) |