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.

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.

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.