Hi my name is Daniel and I haven't used Excel in years!
Trying to autopopulate a prefix of PC- infront of pasted numbers ex: PC-347456
I need to enter 100s of numbers but have PC- in front of them.
Hi my name is Daniel and I haven't used Excel in years!
Trying to autopopulate a prefix of PC- infront of pasted numbers ex: PC-347456
I need to enter 100s of numbers but have PC- in front of them.
dfraz357,
Welcome to the forum!
You could use this formula and copy down:
="PC-"&A1
And then hide the column A.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks