Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to Concatenate with a text & number
A1 will have a 4 digit number and letter (ex: 1332s)
B1 will have a number between 1 & 999 I am trying to get C1 to concatenate the two, taking the B1 value and forcing it to take up 3 spaces EXAMPLE: 1322s002 or 1322s097 or 1322s433 So basically I need to get the number portion from B1 to have 3 place holders currently if B1 is less than 100, ie 99 or 72 or 3 or something, C1 shows up as: 1322s99, or 1322s72, or 1322s3 instead of: 1322s099, 1322s072, and 1322s003 Any ideas out there? Thanks!! |
#2
|
|||
|
|||
Try using the text function:
=a1&TEXT(b1,"000") -- Damon Longworth Don't miss out on the 2005 Excel User Conference www.ExcelUserConference.com "|| cypher ||" wrote in message news:1119656441.59adc4a2a6ee8d9e4d973b9a17d55fe0@t eranews... A1 will have a 4 digit number and letter (ex: 1332s) B1 will have a number between 1 & 999 I am trying to get C1 to concatenate the two, taking the B1 value and forcing it to take up 3 spaces EXAMPLE: 1322s002 or 1322s097 or 1322s433 So basically I need to get the number portion from B1 to have 3 place holders currently if B1 is less than 100, ie 99 or 72 or 3 or something, C1 shows up as: 1322s99, or 1322s72, or 1322s3 instead of: 1322s099, 1322s072, and 1322s003 Any ideas out there? Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I concatenate information in Excel and keep the number form | Excel Worksheet Functions | |||
Format Number to Text | Excel Worksheet Functions | |||
Change Text to a number | Excel Worksheet Functions | |||
Change Text to a number | Excel Worksheet Functions | |||
returning a text cell based on a number cell | Excel Worksheet Functions |