| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting an Item into cells with text
How can I insert an asterix * into every cell in a column that already has
text in it without losing the text. For example I have a data base file with about 2000 menu Items in it but I want all the Menu Items to have an (*) in front of it. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Inserting an Item into cells with text
Several suggestions he
http://tinyurl.com/yutbew -- Biff Microsoft Excel MVP "Dolfan13net" wrote in message ... How can I insert an asterix * into every cell in a column that already has text in it without losing the text. For example I have a data base file with about 2000 menu Items in it but I want all the Menu Items to have an (*) in front of it. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Inserting an Item into cells with text
Go to a blank cell to the right of the first entry. Use the concatenate
feature. Then copy, paste special, values to the original field. "T. Valko" wrote: Several suggestions he http://tinyurl.com/yutbew -- Biff Microsoft Excel MVP "Dolfan13net" wrote in message ... How can I insert an asterix * into every cell in a column that already has text in it without losing the text. For example I have a data base file with about 2000 menu Items in it but I want all the Menu Items to have an (*) in front of it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting text into numerous cells for many different files | Excel Discussion (Misc queries) | |||
| Macro - Inserting text to a cell already containg text | Excel Discussion (Misc queries) | |||
| Inserting cells between cells with text | Excel Discussion (Misc queries) | |||
| using data validation and inserting more than one item in a field | Excel Discussion (Misc queries) | |||
| Inserting line breaks into merged text cells. | Excel Discussion (Misc queries) | |||
Linear Mode
