Leading Zeros insert

cmpglobal

New Member
Joined
Mar 30, 2015
Messages
1
Hi I am new to this board and have tried every solution to inserting leading zeros.

My question is how to insert leading zeros to the following cell entry?

206A
206B
206C
206T

I have tried the format function but this does not work due to the fact I have a letter on the end of the cell entry.

Please help I have over 2000 cell entries on one column.

Thanks.
 

rgs694

New Member
Joined
Sep 18, 2013
Messages
28
Hi,
Since the cells are already text due to the trailing letters, you could concatenate a zero into the cells using a helper column. If your first cell is A1 and contains "206A", then enter this formula into B1 and drag down:

=CONCATENATE(0,A1)

Then you can copy and paste-value the data in column B back in to column A.

-R
 

Forum statistics

Threads
1,081,545
Messages
5,359,444
Members
400,528
Latest member
Ratish52

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top