I wanted to add ,AC to a row of numbers. How do I do that?
EX: 12345 needs to change to 12345,AC and then so on going down
I wanted to add ,AC to a row of numbers. How do I do that?
EX: 12345 needs to change to 12345,AC and then so on going down
Say data in Col A starting in A1 enter the below into B1 and drag down
=A1&",AC"
Then select col B and Format cells > paste special values
VBA Noob
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
say I have a description in field A1 and a description in B1, How do I flip the data in B1 to A1?
Just one cell cut and paste
Whole column then Cut ColB and paste where Col A is
VBA Noob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks