Inserting an Item into cells with text

  • Thread starter Thread starter Dolfan13net
  • Start date Start date
D

Dolfan13net

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
How do I preserve font/size when sending text to a different cell 1
Insert multiple .dat files into one pdf without losing color of their graphs 0
Sliding scale for Mark Up 0
Formula, Macro, or VBA code to find and insert 3
Automatically filling a cell from a worksheet based on a selection 2
Function to Insert Text Into a Formula 3
Updateable drop-down menu for an item database? 1

Back
Top