I have the following in columns A1=A00001,A2=A00002,A3=A00004,A4=A00005,A5=A00006. I would like to convert it to A00001-A00002 and A00004-A00006 in Excel. Please help
Convert sequence of alpha-numeric to range (A00001-A00002 & A00004-A00006)
I tried using Sequence to get the results. But unable to covert it to range
I have the following in columns A1=A00001,A2=A00002,A3=A00004,A4=A00005,A5=A00006. I would like to convert it to A00001-A00002 and A00004-A00006 in Excel. Please help
New contributor
Dhinu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.