Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need a formula to concatenate A1,B#,C1; and place the result in D2, D3, D...
A B C D 1 dog100 0000 red "" 2 0001 dog1000001red 3 0002 dog1000002red A1: Does not change its location. It is an absolute reference. It is in general format, a combination of text and a number. It is imported that way. B2: is a custom format number of the form "0000". I have to keep all the digits. It is derived from a formula to increment the # in the previous column, by one. C3: Does not change its location. It is an absolute reference. It is Text. What I want is to end up with D2, D3,.. a combination of text and value, derived by combining A1,B...,C1. Then copy the formula down the D column, so it will referentialy calculate the next answer. Can someone help me put together text + numbers that increment? Thanks, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
roundoff when converting text to numbers | Excel Worksheet Functions | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) |