Weight with text. removing text changes weight to date.

[xluserg]

hi all

googled with no joy.

I have a weight with text when I remove the text it changes the weight to a date. But I need just the weight to stay as it is.


in a cell I have 8-10 p

I remove the space and the p by macro. could be space then any other text.

changes to 08-Oct I just need it to show 8-10

Thankyou


Graham

 

[dcardno]

If you format the range you are dealing with as "text" format, when you remove the " p" suffix the cell will still display "8-10." You could do this before you run the macro to delete the suffixes, or make it part of the macro (set the cell's numberformat property to "@"). Alternatively, you could change the macro to enter an apostrophe before the cell value when you are removing the " p" suffix.

 

[xluserg]

Hi Dean


could'nt get your first method to work so used your second method, that worked fine!


Thanks Dean.


Brilliant!


Graham

 

[Peter_SSs]

Sounds like you are sorted, but here is yet another method if the text part always has a space before it.
Select the column by clicking its heading label -> Data ribbon tab -> Text to Columns -> Delimited -> Next -> Mark the Space box -> Next -> (first column at the bottom should be highlighted) Choose Text at the top -> Click in the 2nd column at the bottom & choose Do not import at the top -> Finish