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

=RIGHT(A1,LEN(A1)-7)


"Randy Bratton" wrote:

I need a formula that will delete the first seven characters in every cell in
a column. Thanks
--
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)?
--
Randy Bratton


"Teethless mama" wrote:

=RIGHT(A1,LEN(A1)-7)


"Randy Bratton" wrote:

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

Hi Randy

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

Best try on a copy of your data to begin with - just in case!!!
--
Regards

Roger Govier


"Randy Bratton" wrote in
message ...
I need a formula that will delete the first seven characters in every
cell in
a column. Thanks
--
Randy Bratton

Randy Bratton wrote:
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

PERFECT! Thanks so much!
--
Randy Bratton


"Beege" wrote:

Randy Bratton wrote:
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

Randy Bratton wrote:
PERFECT! Thanks so much!

You're quite welcome, thanks for feeding back!

Beege