Drop the first 4 digits from a column

  • Thread starter Thread starter hoganc
  • Start date Start date
H

hoganc

that works great but it hasn't taken away the last / mark E C803/3530 s
it looks like thi
 
Hi
describe exactly what to create. Do you mean
="E" & MID(A1,5,4)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List of Codes and Display Names for Codes 1
Drop the first 4 digits from a column 1
Help this is wrecking my head!! 1
Windows 10 Activate windows now message 3
Horserace Form Revisited 2
Descending Numbers 11
why won't text-to-columns work here? 6
Windows 10 Do you use the Windows App Store? 7

Back
Top