add * to end of each value in column?

  • Thread starter Thread starter viveleroi0
  • Start date Start date
V

viveleroi0

how can I add an * to the end of each value in a column of about 900
cells?
 
Hi!


If A1 has value "a", put in B1 =A1&"*".

This will give you "a*" in B1.

Al
 
You must log in or register to reply here.

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

Add columns to reach a predetermined value 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Formula help please 2
Sort with IF functions? 5
How to use pivot table to count repeats of unique fields 4
separate lines in excel 4
VBAscript for data matching excels 0
select a column, then add rows of each column 3

Back
Top