Need help with putting an 'S' in front of numbers

**travhaughton7** · 07-12-2013, 09:42 AM

I have a list of ip's and I need help with adding a capital S in front of the list of ip's for every IP with no space in between

**jeffreybrown** · 07-12-2013, 09:45 AM

Hello & Welcome to the Forum,

Let's say your list of IPs is in A1:A100, in B1 use ="S"&A1 and copy down

**travhaughton7** · 07-12-2013, 10:26 AM

Thanks very much ive got it now

**jeffreybrown** · 07-12-2013, 10:29 AM

You're welcome…glad you have a workable solution and thanks for the feedback...

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Re: Need help with putting an 'S' in front of numbers