Remove character from the entire row

[mosellv]

Hello, Professionals!

I have a column with some IDs and I need to remove first character form the entire row. Could you please advise which function can be used to delete first character in whole column? Thanks for any help!!!

For ex: A1223456789
B2345678900

Needed result : 1223456789
2345678900

[VBA Noob]

Maybe something like.

Need to select the range first

Please Login or Register  to view this content.

VBA Noob

[solnajeff]

Hi

If you want to use a formula you can use the replace function

Please Login or Register  to view this content.

What that means is your first part is the cell reference, e.g. A1, second part is the starting point in the string, in your case 1, the number of characters to replace is 1, and finally new text will be "", a null value. This will reduce the cell value by the left character, leaving the remainder.

Regards


Jeff

[mosellv]

Thank you!!!