Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calc questions

Status
Not open for further replies.
DKailen

DKailen

Technical User
Mar 6, 2010
13
US
I am using calc and have ran into a problem

I have ~5500 rows and in one column I need to add "pics/" to the beginning of the value.

I cannot seem to grasp this for some reason. Any ideas?

Thanks
Jim
 
Sort by date Sort by votes


hi,

In an adjacent unused column, if your data is in column A starting in row 2...
[tt]
="pics/"&A2
[/tt]

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dik
  • Locked
  • Question
Page Break in Libreoffice Calc 1
Replies
2
Views
273
dik
dik
teron
  • Locked
  • Question
Generate OpenOffice Calc
Replies
2
Views
162
kjv1611
kjv1611
undoIT
  • Locked
  • Question
Window > Freeze Not Working in OOO Calc
Replies
3
Views
105
SkipVought
S
kestrel1
  • Locked
  • Question
Calc Conditional formatting
Replies
4
Views
59
kestrel1
kestrel1
robertedmed
  • Locked
  • Question
new to calc??
Replies
1
Views
49
jad
jad

Part and Inventory Search

Sponsor

Back
Top