copy selected part number of text from one cell into another cell

O

orewa

Hi

Can anyone help me.

I have a database where a cell has text or numbers (example Cell: B1:
contains company name : excel corporation 2008 Limited

I need to copy the first 4 characters in cell B1: into A1: EXCE

I also need the text to be in uppercase in A1 even when lowercase in B1.

Assume I need to change the number of characters copied over from 4 to 2 or
6. How would the formula change?

If the excel sheet I was working on had 1000 rows of data, would I just drag
the formula down from A1 to A100?

Any suggestions will be greatly appreciated.
 

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

Date converts to number when part of a formula 3
Combining Text From Cells 3
Count Text Characters in cell 1
linking a text formatted cell to a formula cell 2
copy and paste the cell with formula ="1" 3
how to cut part of a text from one cell and automatically paste itonto another cell 6
Excel In Excel how can I block the contenent of a cell? 0
protect cell format 1

Top