I am working on a data entry project with Microsoft Excel and I have a problem. My data comes in two long columns:
In column 1A I have: SC-
In column 1B there could be any number made of 1 to 4 digits, sometimes combined with letters (e.g. 23, 32.65b or D48)
What I want is to add the numbers and letters in column 1B to the SC- in column 1A. This may be a very tedious process if I use the F2 key to do 1 row at a time.
I want to know if there’s any way to combine the two columns in A so I get mixed numbers and letters (e.g. SC-23, SC-32.65b etc.), leaving the B column untouched.
If you have any solution, please let me know