Inserting same characters to text strings in several cell

**10036760** · 10-02-2007, 06:48 PM

Does anyone know how to insert same characters to text strings in several cells using formula?

Mark

**VBA Noob** · 10-02-2007, 06:50 PM

Can you give an example of what your trying to do

VBA Noob

**10036760** · 10-02-2007, 06:58 PM

Hi VBA Noob,

Example below. The column on the left is the original data and the column on the right is what I am trying the accomplish.

SpyA Spy1A
SpyB Spy1B
SpyC Spy1C
SpyD Spy1D

Thank you.
Mark

**VBA Noob** · 10-02-2007, 07:01 PM

Try

=LEFT(A1,3)&ROW(A1)&"A"

VBA Noob

**10036760** · 10-02-2007, 07:14 PM

Hi VBA Noob,

I don't know if you noticed that I have revised my example. Does your formula still apply?

Thanks,
Mark

**VBA Noob** · 10-02-2007, 07:17 PM

No I didn't and No it doesn't

Try

=LEFT(A1,3)&ROW(A1)&RIGHT(A1,1)

VBA Noob

**10036760** · 10-02-2007, 07:27 PM

Got it! Thank you so much!!!
Mark

Inserting same characters to text strings in several cell

LinkBack

Thread Tools

Rate This Thread

Display

Inserting same characters to text strings in several cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions