R
Randy Bratton
I need a formula that will delete the first seven characters in every cell in
a column. Thanks
a column. Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Teethless mama
=RIGHT(A1,LEN(A1)-7)
R
Roger Govier
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!!!
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!!!
R
Randy Bratton
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)?
same column that I want to apply the formula to. Would it be written as
=Right(A1-A50,LEN(A1-A50)-7)?
B
Beege
Randy said:I need a formula that will delete the first seven characters in every cell in
a column. Thanks
Try Text to Columns, Fixed width, do not import first column.
Beege
R
Randy Bratton
PERFECT! Thanks so much!
--
Randy Bratton
--
Randy Bratton
Beege said:Try Text to Columns, Fixed width, do not import first column.
Beege
B
Beege
Randy said:PERFECT! Thanks so much!
You're quite welcome, thanks for feeding back!
Beege