Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Remove Leading Spaces
I've got a column of cells filled with Product ID's. They all have a space
at the beginning, such as ' 9025342 ' 1023456 I've tried Trim, LTrim, Clean, etc, etc. Nothing seems to work on these cells. Any ideas? |
#2
|
|||
|
|||
Assuming all entries have the apostrophe-single space combo at the beginning
of the product number, try this: =RIGHT(A1,LEN(A1)-2) "Kirk P." wrote in message ... I've got a column of cells filled with Product ID's. They all have a space at the beginning, such as ' 9025342 ' 1023456 I've tried Trim, LTrim, Clean, etc, etc. Nothing seems to work on these cells. Any ideas? |
#3
|
|||
|
|||
In a standard module paste in:
Sub nopreapostophe() For Each c In Selection If c.PrefixCharacter = "'" Then c.Value = c.Value Next End Sub Back at the worksheet, Highlight/Select your desired range of Cells to examine/fix. And then run: nopreapostophe() HTH "Michael Malinsky" wrote in message ... Assuming all entries have the apostrophe-single space combo at the beginning of the product number, try this: =RIGHT(A1,LEN(A1)-2) "Kirk P." wrote in message ... I've got a column of cells filled with Product ID's. They all have a space at the beginning, such as ' 9025342 ' 1023456 I've tried Trim, LTrim, Clean, etc, etc. Nothing seems to work on these cells. Any ideas? |
#4
|
|||
|
|||
Sorry, I got your Q confused with another Q asked by someone - their Q,
which had to do only with the removal of the " ' " preceeding a bunch of numbers.. "Jim May" wrote in message news:4ZDVd.30376$7z6.29057@lakeread04... In a standard module paste in: Sub nopreapostophe() For Each c In Selection If c.PrefixCharacter = "'" Then c.Value = c.Value Next End Sub Back at the worksheet, Highlight/Select your desired range of Cells to examine/fix. And then run: nopreapostophe() HTH "Michael Malinsky" wrote in message ... Assuming all entries have the apostrophe-single space combo at the beginning of the product number, try this: =RIGHT(A1,LEN(A1)-2) "Kirk P." wrote in message ... I've got a column of cells filled with Product ID's. They all have a space at the beginning, such as ' 9025342 ' 1023456 I've tried Trim, LTrim, Clean, etc, etc. Nothing seems to work on these cells. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove all spaces in a text string | Excel Discussion (Misc queries) | |||
remove spaces in text in excel | Excel Discussion (Misc queries) | |||
how do I remove spaces from cells that were pasted | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) |