Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I enter a prefix number to a colum of numbers
I need to enter a prefix number (BC5) to each number in a colum of numbers.
|
#2
|
|||
|
|||
Newbee101l Wrote: I need to enter a prefix number (BC5) to each number in a colum of numbers. Assuming that your numbers are in Column A and starting at Cell A1, enter this formula in Cell B1 ="BC5"&A1 and copy down until the cell opposite the last number in Column A. Is this the solution that you are looking for? -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=318646 |
#3
|
|||
|
|||
You the Man Benjie. Thanks a couple of thousand, literally.
"Newbee101l" wrote: I need to enter a prefix number (BC5) to each number in a colum of numbers. |
#4
|
|||
|
|||
Thanks for the feedback ... I am just glad that I can help. Regards. newbee101 Wrote: You the Man Benjie. Thanks a couple of thousand, literally. "Newbee101l" wrote: I need to enter a prefix number (BC5) to each number in a colum of numbers. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=318646 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
How do you enter numbers in a fraction format ? (78/27) | Excel Discussion (Misc queries) | |||
The number change from 1350 to 13.5 and Enter does not function properly | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
I enter numbers and they are stored as text | Excel Discussion (Misc queries) |