Need a simple formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a formula that will delete the first seven characters in every cell in
a column. Thanks
 
Hi Randy

in another column
=MID(A1,8,255) copy down as far as required.
Then, copy the new column and Paste Special>Values to "fix "the data

Best try on a copy of your data to begin with - just in case!!!
 
Sorry I wasn't more specific - I actually have a range of 50 cells in the
same column that I want to apply the formula to. Would it be written as
=Right(A1-A50,LEN(A1-A50)-7)?
 
Randy said:
I need a formula that will delete the first seven characters in every cell in
a column. Thanks
Click to expand...

Try Text to Columns, Fixed width, do not import first column.

Beege
 
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

Counting Formula 3
Sum of yes answers 2
Summing every 7 cells consecutively 4
Excel VBA 1
Summing based on dates 2
Summing based on dates 3
Help needed 0
Hiding Formula Answers in Specific Cells 1

Back
Top