| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Repetative text
Thank you so much, great help!!!
"Roger Govier" wrote: Hi Sue Assuming the data is contiguous in the 200 rows, and assuming column A for this example In cell B1 =IF(A1="","",A1&" RS") copy down through B2:B200 Copy column B Paste SpecialValues back over column A Delete column B. -- Regards Roger Govier "smack" wrote in message ... Hi All, I have approximately 200 rows of data and would like to add "RS" to the end of each instruction example: NOW; Adjust nuts and bolts WOULD like it to read; Adjust nuts and bolts RS Any suggestions are appreciated, Sue |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
| Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
| Repetative Row Deletes | Excel Discussion (Misc queries) | |||
| text (3750 char.)truncates with text wrap and row heigh adjusted? | Excel Discussion (Misc queries) | |||
| convert a range of lowercase text to upper text or vice versa | Excel Worksheet Functions | |||
Hybrid Mode
