Replacing automatically

  • Thread starter Thread starter adrianfleming
  • Start date Start date
A

adrianfleming

I am trying to update a large range of entries (about 1,500
automatically. For example the entry 12345 I need to copy into a ne
column and change it to 12345.eps .Does anybody know a way to do thi
as the replace function does not seem to have an option to do this.
am using Excel on a Mac OSX if that helps but I can use a PC with XP i
require
 
=CONCATENATE(A1,".eps")

A1 being whatever data you want to add .eps t
 
Or alternately:

in B1, put in the formula = $A1 & ".eps" and then drag down to creat
the appropriate formula in column
 
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

Formula Question 2
useform label enter 1
GETTING RID OF LEADING HASH MARKS 5
Formatting Decimal points 2
Incrementing Data based on user input 3
Do I need a Macro to do Transpose in this case? 3
create 1 master list from a combination of rows and columns 3
Conditional Insert Row 2

Back
Top