Microsoft Office Forums - View Single Post - [Solved] Trying to change the last digit in a column of 10 digit entries

Thread: [Solved] Trying to change the last digit in a column of 10 digit entries

View Single Post

Old

04-01-2020, 03:26 PM

arkansawyer16 arkansawyer16 is offline

arkansawyer16 is offline

arkansawyer16 uses Windows 10

Windows 10 arkansawyer16 uses Office 2019

arkansawyer16 uses Office 2019

Office 2019

Novice

The original poster

Join Date: Apr 2020

Posts: 2

arkansawyer16 is on a distinguished road

Default

I appreciate your answer. It took out the first digit and added the 5. I tried doing a =LEFT(A1,9)&"5" and this did what I was looking to do.
Thanks for your help.

Reply With Quote