Thread
:
SD03*10 -how do I just get the numbers at the end in cell after *
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
L. Howard Kittle
external usenet poster
Posts: 698
SD03*10 -how do I just get the numbers at the end in cell after *
Data Text to columns should work well...
Delimited Other * Finish
HTH
Regrds,
Howard
"Helen Maguire" <Helen
wrote in message
...
,I have SD03*10 in a cell and I want in a separate cell, just to have the
numbers after the *. Obviously with lots of data, the digits after the *
could be 1 to many characters so I cannot use the Left function.
Any help would be greatly appreciated so I don't waste any more time!
Reply With Quote
L. Howard Kittle
View Public Profile
Find all posts by L. Howard Kittle