Delete the first 4 charcters then Keeping the

[Solved/Closed]
Report
-
 Angel1 -
Hello,


In excel macro, how can I delete the first 2 characters and THEN keeping the first 5 characters and THEN deleting the rest. The data is in column A and I want the result in column B.

For example: If cell a shows: AXBbing25, after deleting 1st two characters and then keeping the first 5 would giveme Bbing in cell B.

Please help. Thank you in advance.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
if the data you have given is entered in A14
in B14 copy this formula

=MID(A14,3,5)
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Nice! Thank you.....