| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 07 - Combining Number minus the excess wording
I have numbers that represent code/state and would like to combine them in
one cell (Column B) where the "xxxx". Column A starts with the code needed but I do not need the extra wording - just the first 4 numbers. Example: A B C Atlanta 00100 3000 - Bill xxxx 4930 3001 - Legal xxxx 5690 Results - I looking for 1 A B C 2 Atlanta 3 00100 4 3000 - Bill 300000100 4930 5 3001 - Legal 300100100 5690 Column A4:A5 = code (just the first 4 numbers) Column $C$3 = state Column B = formula to combine the two (code_state) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 07 - Combining Number minus the excess wording
Hi,
same as last time in B4 and drag down =LEFT(A4,4)&$C$3 Mike "Ms. D" wrote: I have numbers that represent code/state and would like to combine them in one cell (Column B) where the "xxxx". Column A starts with the code needed but I do not need the extra wording - just the first 4 numbers. Example: A B C Atlanta 00100 3000 - Bill xxxx 4930 3001 - Legal xxxx 5690 Results - I looking for 1 A B C 2 Atlanta 3 00100 4 3000 - Bill 300000100 4930 5 3001 - Legal 300100100 5690 Column A4:A5 = code (just the first 4 numbers) Column $C$3 = state Column B = formula to combine the two (code_state) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 07 - combining number | Excel Discussion (Misc queries) | |||
| translate number in dollars to wording in excel 2003 | Excel Discussion (Misc queries) | |||
| How do i convert number to wording | Excel Discussion (Misc queries) | |||
| can I get cells with a minus number to show zero | Excel Discussion (Misc queries) | |||
| How can i get a minus number to appear as a 0? | Excel Worksheet Functions | |||
Linear Mode
