| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing a last digit to something else
Hi all,
I hope you can help me. I have a huge excel spreadsheet and all I want to do is replace the last digit in each cell, no matter what it is, number or letter, into an L or an M. One worksheet will be "L"'s and one will be "M"'s. My biggest concern is just changing the last digit. Any ideas? Thank you very much in advance! Jen |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Replacing a last digit to something else
Sub replacelastchrwithM()
For Each c In Selection c.Value = Left(c, Len(c) - 1) & "M" Next c End Sub -- Don Guillett SalesAid Software wrote in message ups.com... Hi all, I hope you can help me. I have a huge excel spreadsheet and all I want to do is replace the last digit in each cell, no matter what it is, number or letter, into an L or an M. One worksheet will be "L"'s and one will be "M"'s. My biggest concern is just changing the last digit. Any ideas? Thank you very much in advance! Jen |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Replacing a last digit to something else
Jen
Use a helper column alongside the current one and a formula (Presume A) =LEFT(A1,LEN(A1)-1)&"L" -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk wrote in message ups.com... Hi all, I hope you can help me. I have a huge excel spreadsheet and all I want to do is replace the last digit in each cell, no matter what it is, number or letter, into an L or an M. One worksheet will be "L"'s and one will be "M"'s. My biggest concern is just changing the last digit. Any ideas? Thank you very much in advance! Jen |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Replacing a last digit to something else
Thank you! That worked wonderfully. Now, my next question is how to
change only the third digit in a cell to an "L". The number would look something like 150-123-456. I would want to change the 0 into an "L". How would I do that? Thanks in advance! Jen Nick Hodge wrote: Jen Use a helper column alongside the current one and a formula (Presume A) =LEFT(A1,LEN(A1)-1)&"L" -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk wrote in message ups.com... Hi all, I hope you can help me. I have a huge excel spreadsheet and all I want to do is replace the last digit in each cell, no matter what it is, number or letter, into an L or an M. One worksheet will be "L"'s and one will be "M"'s. My biggest concern is just changing the last digit. Any ideas? Thank you very much in advance! Jen |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Replacing a last digit to something else
=LEFT(A1,2)&"L"&RIGHT(A1,LEN(A1)-3)
-- David Biddulph wrote in message ups.com... Thank you! That worked wonderfully. Now, my next question is how to change only the third digit in a cell to an "L". The number would look something like 150-123-456. I would want to change the 0 into an "L". How would I do that? Thanks in advance! Jen Nick Hodge wrote: Jen Use a helper column alongside the current one and a formula (Presume A) =LEFT(A1,LEN(A1)-1)&"L" -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk wrote in message ups.com... Hi all, I hope you can help me. I have a huge excel spreadsheet and all I want to do is replace the last digit in each cell, no matter what it is, number or letter, into an L or an M. One worksheet will be "L"'s and one will be "M"'s. My biggest concern is just changing the last digit. Any ideas? Thank you very much in advance! Jen |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Replacing a last digit to something else
Thank you SOOOO much!! That worked like a charm! I am on Cloud 9! This
makes my work so much easier and faster!! You guys are awesome! I cannot thank you enough! Jen David Biddulph wrote: =LEFT(A1,2)&"L"&RIGHT(A1,LEN(A1)-3) -- David Biddulph wrote in message ups.com... Thank you! That worked wonderfully. Now, my next question is how to change only the third digit in a cell to an "L". The number would look something like 150-123-456. I would want to change the 0 into an "L". How would I do that? Thanks in advance! Jen Nick Hodge wrote: Jen Use a helper column alongside the current one and a formula (Presume A) =LEFT(A1,LEN(A1)-1)&"L" -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk wrote in message ups.com... Hi all, I hope you can help me. I have a huge excel spreadsheet and all I want to do is replace the last digit in each cell, no matter what it is, number or letter, into an L or an M. One worksheet will be "L"'s and one will be "M"'s. My biggest concern is just changing the last digit. Any ideas? Thank you very much in advance! Jen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I Calculate Check Digit for UPC A - the 13th warrior | Excel Discussion (Misc queries) | |||
| Sorting by 5 digit & 5 digit plus 4 zip codes | Excel Worksheet Functions | |||
| Replacing last digit with Zero | Excel Worksheet Functions | |||
| Return a digit in a string of numbers | Excel Discussion (Misc queries) | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
Linear Mode
