Hi all,
My first post here, I am a bit nervous.
First off, I consider myself as belonging to the pool of 99% Excel users who use 1% of its power.
Came across this forum the other day and it looked like the right place to ask questions.
Let me begin with the data structure:
ColumnA | ColumnB
AAA | 12345678
BBB | 90123456
I am trying to format the integer numbers in ColumnB in the following way:
If ColumnA reads AAA, add TRAILING zeros to the number in ColumnB of the same row until there are 14 digits there.
If ColumnA reads BBB, add LEADING zeros to the number in ColumnB until there are 10 digits there.
Could you guys/gals give me some examples on how this could be done?
Since there are potentially hundreds of rows that need to be formatted this way, doing this manually is a nightmare.
Thanks in advance
My first post here, I am a bit nervous.
First off, I consider myself as belonging to the pool of 99% Excel users who use 1% of its power.
Came across this forum the other day and it looked like the right place to ask questions.
Let me begin with the data structure:
ColumnA | ColumnB
AAA | 12345678
BBB | 90123456
I am trying to format the integer numbers in ColumnB in the following way:
If ColumnA reads AAA, add TRAILING zeros to the number in ColumnB of the same row until there are 14 digits there.
If ColumnA reads BBB, add LEADING zeros to the number in ColumnB until there are 10 digits there.
Could you guys/gals give me some examples on how this could be done?
Since there are potentially hundreds of rows that need to be formatted this way, doing this manually is a nightmare.
Thanks in advance