LinkBack URL
About LinkBacks
What would the formula be to add a suffix in a series of numbers?
Example:
51-4001 should be 51-4001PHM
Thanks!
What would the formula be to add a suffix in a series of numbers?
Example:
51-4001 should be 51-4001PHM
Thanks!
If it's just for appearance sake, you can format the cells
Format Cells> Custom> General; @"PHM"
Otherwise, you'll need to concatenate in another cell and Paste Special > Values back into the original cell.
=IF(A1<>"", A1&"PHM", "")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you. It worked for the one cell but I need to drag it down the column but the numbers are random numbers and not in sequence.
Which worked? The Formula?
Just copy the formula down the column. The cell reference (i.e. A1) will automatically change as you copy it down. For clarity, you could attach an example workbook (Go Advanced> Manage Attachments)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks