Cross Referance

N

Nathan

I am creating a spread sheet, there is alot of repeated
item but there is differant prefixes in from of them all.
i was wondering if there was a way i could take a cell
from one sheet to another sheet with a differant prefix

eg.
sheet = Web Sites
cell = B5
cell contents = hershaltech.com

i want to take that cell and add it a part of another cell

sheet = FTP
cell = B5
cell contents = ftp.hershaltech.com

is there a formula i can use or another way i can do it
automatically without having to type it all in???

thanks
nathan
 

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

Top